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.

sql database oracle-database
Edit
Report