Could someone point me to a tutorial on the query syntax used in paradox 8.0 scripts. I'm debugging a script, and the queries are in this format.

Table1.db | T1Col1 | T1Col2 |
| _join1 | _T1Col2 |


Thanks

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.

thanks, that wasn't a real query I just made it up to show what the format was. I did find a paradox 4.5 book, which explains queries in this format.