General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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...
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only