Help with query please 1

[pkailas]

I have 2 tables BOLS and BOLINOB

BOLS has columns BOLNUM, ORDERNUM, INVNUM, LOCATION, SHIPTO1, SHIPDATE, ENTERDATE

BOLINOB has columns BOLNUM, ORDERNUM, INVNUM

I need to list the rows that ARE IN BOLS but NOT IN BOLINOB.

BOLNUM, ORDERNUM, INVNUM make the record unique. All 3 must be equal.

_______
I love small animals, especially with a good brown gravy....

 

[manjarikosaraju]

select * from BOLS a
where not exists (select distinct b.BOLNUM, b.ORDERNUM,b.INVNUM from BOLS b join BOLINOB c on b.BOLNUM = c.BOLNUM and b.ORDERNUM = c.ORDERNUM
and b.INVNUM = c.INVNUM and b.BOLNUM = a.BOLNUM and b.ORDERNUM = a.ORDERNUM and b.INVNUM = a.INVNUM)

-Manjari

 

[pkailas]

Thanks Manjari

I was overcomplicating it!

_______
I love small animals, especially with a good brown gravy....