Match Query

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I have two tables (related) and I want a query that will
show records when
two fields match from each table, two from table one, two
from table two.
Table1 Table2
Last Name Last Name
Item# Item#

Any suggestions?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query on two tables with matching null fields 4
Have both records from two queries/tables under one Query without related fields. 0
Joining two tables 2
expesssion in query 4
Compare and fill from table 2 to table 1. 0
Complex Queries 1
Count the receipt# if .. 7
Merging data in a one-to-many relationship 5

Back
Top