join tables based on matched columns and closest match column
Hi,I want to join two tables.I have full match on two column and closest match on two other columns.Each table with different number of row.reference sorted= 108 rowsscan sorted= 193 rowsI want the final table to have all the row from the reference table, 108 rows, + the matching data from the second table.exact match columns:1. Row Reference= Row Scan2. Col Reference= Col Scanclosest match column...