On Thu, 2008-06-05 at 08:27 -0400, Drew Jensen wrote: > 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.
Perfect Drew! Sorry for the delay in getting back to you, several other, unrelated problems came up! Keith --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
