Drew Jensen wrote:
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.
Well, given silence I guess I know what you are really asking.
No - you can not use the EXCEPT construct in the GUI designer, in fact
you must turn off escape processing.
So - if table1 and table2 have identical structures it is simply
SELECT * FROM Table1
EXCEPT
SELECT * FROM TABLE2
entered into a Query Definition window using SQL View mode and setting
on the RUN SQL Direct tool button.
That will give you any records that in either table and not the other.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
