Query using multiple tables

[Dave B]

I have 2 tables, one contains ID number, date, Company ID, DriverName, Miles
and Hours. The 2nd table contains Driver name, SSN, 2 other numbers, and
PayMiles and Pay Hours. The DriverName field is indexed in both tables. The
Drivre Name filed in both tables is connected.

When I develop a select query using both tables I get blank results. I can
do a query using the 1st table and ask for a certain date and the information
shows properly.

What is the secret to getting all of the 1st table information as well as
the Pay Miles and Pay Hours from the 2nd table?

 

[Golfinray]

Right click on the line between the two tables and it will give you 3
options. Select the second.