What you posted looks like an attempt to do an external join using cols 1 and two of table 1 but there is no reference to the second table. the underline preceeding the text indicates that an example element has been placed in the column (field). That example element should be repeated in the corresponding column of another table. Depending on the query type it could repeat in multiple tables all being required to match records based on that column(s). If you need more details go to help or get a book (even an older book on Paradox for Dos would still explain the syntax of the queries which haven't changed.