matches columns for two separate tables

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

Guest

Query to find like numbers in columns that are in two separate tables? For
example, I have one table with telephone numbers in a column and I want to
see the matching telephone numbers in a column in a separate table.
 
Query to find like numbers in columns that are in two separate tables? For
example, I have one table with telephone numbers in a column and I want to
see the matching telephone numbers in a column in a separate table.
Click to expand...

That's exactly what relational databases are designed to do!

Create a Query using the New Query option. Add the two tables to the
query window. Drag the field on which you wish to join from one table
to the other. Select whichever fields you want to see from the two
tables; save the query, and open it by either clicking the leftmost
toolbar icon or by doubleclicking the query name in the Queries
window.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top