Trying to..: find all IDNumbers from one table that are not in EITHER
of TWO other tables. Doing one is no sweat, via a left join. Tried
adding a second left join, but doesn't get the right results. Is there
a statement in SQL I can throw in to get the job done, or am I looking
at 2 separate queries?
To clarify, here's an example with simplified data, where yes or no
indicates the presence or absence of the given Idnumber:
IDNUMBER(from TableA) TABLE B TABLE C
1 yes no
2 no yes
3 no no
The only record I'd want is #3.
Thanks
Martin Lacoste