Hey,
I am having some trouble using the a unmatched query. Bascially I have 3 tables(Master, Table1 and Table2). In the three tables I have a unqiue field(Not the Primary) named ID#. I want to run a query on Master table and return the ID# if it is not listed in either Table1 or Table2.
Any help would be great.
Thanks
I am having some trouble using the a unmatched query. Bascially I have 3 tables(Master, Table1 and Table2). In the three tables I have a unqiue field(Not the Primary) named ID#. I want to run a query on Master table and return the ID# if it is not listed in either Table1 or Table2.
Any help would be great.
Thanks