Building Queries

[kje7713]

I have two tables:

Table 1
Name
DATA FIELD 1

Table 2
Name
DATA FIELD 2

In the query I need all the names from table 1, data field 1, and data field 2. However, only some of the names in Table 1 also exist in Table 2 (i.e. its a selection of the names where data field 2 is applicable, rather than all Names with 0s or blanks where a name has no data field 2).

My query is being limited by the number of names in Table 2, rather pulling in all names from Table 1, and where applicable Data Field 2.

Any thoughts on how to accomplish this?

[June7]

Change the query jointype to "Include all records from Table1 and only those from Table2 ..."