Kenneth,

Try this

select * from table1 where field1 in (select field1 from table2 where x=y)

This type of query should work. What you were missing was the in clause.

Jeff Whitaker


>It appears that fox does not support the syntax SELE * FROM (SELE ...).
>
>Am I missing something or do I have to do one query and then the next?
>
>As always, TIA...