>
>Thanks again! My difficulty was put in the last condition. Ahhh.. Finally I got ti straighten out as follows:
>
>select journal.*, main.summaryid, main.submitter from journal, main where journal.summaryid=main.summaryid and journal.summaryid in (select summaryid from main where keywords like '%11B%')
>
>I'll try "inner join" later to see if the line is shoter. I do need the submitter field from MAIN.DBF and all the fields in the JOURNAL.DBF to show a search result.

not shorter or faster, just 'more proper'...