>FP 2.6, DOS. I've got two tables and connect them with a SQL statement using »WHEN first.key = second.key«. It works fine until in the second table doesn't exist a related record. In that case the record
>from the first table is ommited in the result of a SQL. Is it possible to make a statement as in VFP with »LEFT JOIN« option in FP 2.6? I know I could make a solution programming a DO... loop, but I prefer using a simple and faster SQL statement.
>
Not trivially; you can do this with a UNION and a subquery as the basis of a NOT IN clause.