2 Tables - Return only Shared Reslts

  • Thread starter Thread starter orbojeff
  • Start date Start date
O

orbojeff

I have 2 Tables with Contact information.
Some of the contacts are shared while some of the contacts are unique
to each individual Table.

I want a Query to return only the contacts in Table 1 that also exists
in Table 2
I also want to return the addresses from Table2 for each common record

Jeff
 
Create a query that uses both tables.

In the upper pane of query design, join the 2 tables by dragging the field
from Table2 and dropping onto the matching field of Table1. For example, if
you want to match the data based on the FirstName and Surname fields, drag
Table2.FirstName onto Table1.FirstName, and then Table2.Surname onto
Table1.Firstname. You would see 2 lines joining the tables, and these joins
will limit the output to only results that match.
 
Back
Top