'SQL Query to find missing rows between two related tables

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.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source