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.
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.