Oracle: queryi have a two two tables table-A and table-B i need to compare two columns:- from these tablescolumn1 from tble-A column2 from table-Bwhere column A records have two extra characters at th

Oracle: query

i have a two two tables table-A and table-B i need to compare two columns:- from these tablescolumn1 from tble-A column2 from table-Bwhere column A records have two extra characters at the end of each recordso in order to match these two columns...tableA column shouhld ignore last two characters while comparing with table B