I have 2 tables where only 2 columns are common in these tables. a.col1 = b.col1 and a.col2 = b.col2. Rest of the columns are different in both tables.
I have the following query and need to get columns from both tables:
FROM tableA a
WHERE NOT EXISTS( SELECT * FROM tableB b
WHERE a.col1 = b.col1
AND a.col2 = b.col2)