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.