finding missing data records.

[cb49747]

hello,

I'm trying to write a query that will show what records are missing from a table.

table A has inv_num and ln_num
table B has inv_num

In table A there can be only one ln_num but multiple inv_num.

In table B there can only be one inv_num.

for every different inv_num in table A there needs to be a corresponding record in table B.

what I need is how to write a query that will tell me if I get a inv_num that does not have corresponding record in table B.

Thanks for any help on this.

 

[hos2]

select a.inv_num,b.inv_num from a left outer join b on a.inv_num=b.inv_num where b.inv_num is null and a.inv_num is not null