Keith Clark wrote:
I have two tables I want to be able to search all values from tbl1 that
do not have a corresponding entry in tbl2.
What is the easiest way to go about this? Can you do it via the GUI
Query Design screen?
Hi kieth,
Search against single column in each table or multiple column?
Is there a common key between the tables?
( so Table1 has record with Key_val = 1 and table2 has a record with
Key_val = 1 also, and they refer to different versions of the same
record in other words, or must this common key be formed during the
search? )
GUI designer...not sure... I'm guessing not, but that doesn't mean that
you couldn't most of it in the GUI designer and then have to switch to
SQL view to add the last part of the statement.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
