make table query SQL question

  • Thread starter Thread starter GaryS
  • Start date Start date
G

GaryS

I want to Make a Table tC consisting of names (one per
record)whose values do occur in tA.name but do not occur
in tB.name.

I can handle the Make Table part fine, I just can't see
how to write the WHERE clause in SQL that will work in
Access (Jet).

TIA
 
In the query window, click the New button and choose the Unmatched query wizard (clicking
the line at the top of the window that says "New query using wizard" won't work, you have
to click the New button). This will walk you through making an unmatched query that will
show items in one table that aren't in the other. You should be able to use this as an
example or as the data source for your Make Table query.
 
Thanks much, Wayne; I DID know about that Unmatched wizard
at one time . . . but it just slipped away :-(

Thanks for bringing it back!

Gary
-----Original Message-----
In the query window, click the New button and choose the
Click to expand...
Unmatched query wizard (clicking
the line at the top of the window that says "New query
Click to expand...
using wizard" won't work, you have
to click the New button). This will walk you through
Click to expand...
making an unmatched query that will
show items in one table that aren't in the other. You
Click to expand...
should be able to use this as an
 
Back
Top