>>>>>All records are coming from both tables. That's how JOIN works.
>>>>>
>>>>
>>>>Even I knew that <g>. But for every record in Table1 the query pulls 1 or more records from Table2. So I was hoping to be able to find the one record that was the "primary" (I know this is not the right word but you know what I mean) record from Table1.
>>>
>>>Put pk into the result!
>>>
>>>Every pk of the table1 is a table1's record.
>>>Every pk of the table2 is a table2's record.
>>
>>I tried this. But the resulting query has both PKs. So just putting PKs in the resulting query does not seem to help. Unless, as Michael suggested, I order on the PK of Table2 and then the row with the smallest PK value from Table2 is the record from Table 1. Thank you for your suggestion.
>
>Assuming
>

>Table1
>PK  NameField
>1      Name1
>2     Name2
>
>Table2
>
>PK FK NameField
>1    1   Test1
>2    1  Test2
>3    2  Test3
>
>You should get as a result of the join
>
>1  Name1  1 1 Test1 - In the first two records first two columns repeat the information
>1  Name1  2 1 Test2
>2  Name2  3 2 Test3
>
>

What columns in your resulting query the column 3 and column 4; the one that you say will repeat the information?