Query assistance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables and I am looking to create a query that will display the data
only if it exists in both tables. I have been doing this in the past by
running 2 unmatched queries, but I am assuming that there must be a faster,
better way and I am hopeful that someone here could help.
 
IF the data has to exist in both tables you could just join the tables on
the relevant field(s). With an inner join the data would have to be in both
tables to return any record.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top