SQL Query to find missing rows between two related tables

Question

I have two tables   Table A   ID ABC ID VAL   Table B   ID ABC ID VAL   These two tables are directly related to each other through the ABC ID column   I want to find all the VAL column values in table A which are not present in table B for the same ABC ID

User · Accepted Answer

SELECT A ABC ID  A VAL FROM A WHERE NOT EXISTS      SELECT   FROM B WHERE B ABC ID   A ABC ID AND B VAL   A VAL    or  SELECT A ABC ID  A VAL FROM A WHERE VAL NOT IN       SELECT VAL FROM B WHERE B ABC ID   A ABC ID    or  SELECT A ABC ID  A VAL LEFT OUTER JOIN B      ON A ABC ID   B ABC ID AND A VAL   B VAL FROM A WHERE B VAL IS NULL   Please note that these queries do not require that ABC ID be in table B at all   I think that does what you want

[sql] SQL Query to find missing rows between two related tables

Examples related to sql

Examples related to database

Examples related to oracle