Skip to Content
0
Former Member
Mar 05, 2009 at 03:02 PM

How do I find missing entries in outer join table?

1252 Views

Hi all,

I am trying to find records in table1 that are missing in table2. This is a simple process in SQL, but ABAP is giving me trouble. I want to do this using an outer join.

Example:

Select table1~docnumber

From table1

Left Outer Join table2

On table1docnumber = table2docnumber

Where table2~docnumber IS NULL. (the record is missing in table2)

Note: ABAP gives an error and wants me to use the Having Clause, which is ok, but then ABAP wants me to use Group By, which ok, but then I still get the same syntex error.

Any thoughts on doing this with the outer join and is null options. I do not want to select into two internal tables and compare them.