a query

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

Hello,
I have two tables, these tables have a field common. I
make one-to-one link and retrieve all that common rows in
both tables, however I also need all the rest of the rows
in the first table. What is the fastest and easiest way
of doing that in access query?
Thanks,
Jim
 
Double-click the join line and select the proper option of the three
presented.
 
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 with common fields to all records 6
VBA - retrieve data on last create named range from previous inserted named range 0
Append Query Issue 0
Split data in field on character return 0
Need a query to get rid of duplicates using two tables 1
update query vs make query 5
add a field in a query for ALL observations, where only the value of the field is available for only 16
Query combining the tables 15

Back
Top