General information
Title:
LEFT JOIN IN SQL for FPD 2.6
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.
Thanks, Zlatko.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only