a query

[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

 

[Duane Hookom]

Double-click the join line and select the proper option of the three
presented.