>This is 1-M Relationship.
>
>Table2 - Parent Table. Field1 is PK field. One record for each Field1 PK
>Table1 - Foreign table. Field1 is a Foreign key. It could have several records for the same value of Field1.
>

:) Usually I would think in reverse that's why it was a bit confusing.

Now, back to the original question - which rows of Table1 do you want to get per single Field1 (PK) in the table2 ?