Information générale
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement