>>I was trying to do a query like in the Visual FoxPro help file but got the "SQL - Subquery is invalid".
>>
>>code: select journal.summaryid from journal where journal.summaryid in (select main.summaryid, main.submitter from main where keywords like "%11B%")
>>
>>Thanks.
>Subquery should select one field here:

>select journal.summaryid from journal ;
>      where journal.summaryid in ;
>      (select main.summaryid from main where keywords like "%11B%")

Cetin
Thanks. That is working. Now, how can I get other information our from both the Journal and Main tables?