Assuming Field2 and Field3 are character type of lenght 50:

SELECT * FROM Table1 WHERE Field1 AND PadR(Field2, 50) + PadR(Field3, 50) IN (SELECT PadR(Field2, 50) + PadR(Field3, 50) FROM Table2)

HTH

>having trouble with the actual sql syntax.
>
>select * from table1 where field1 = .t. into resulttable
>
>now only want the rows from resulttable that have a match on field2 and field3 in table2.
>
>obviously i would prefer to get both things done in a single statement, if possible. this is just the easiest way for me to explain it.