Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Select sql join question ???
Hi guys,
I try to make a select with a join condition on multiple table. But i don't really know the syntax to do this.
i try to make a exemple to clarify my question
ex:
Table1 field : Cust_id, Vend_id
Table2 field : Vend_id, Vend_ Name,...
Table3 field : Cust_id, Cust_Name, adresse,...
SELECT * ;
FROM Table1 LEFT JOIN Table2 ON Table1.Vend_id = Table2.Vend_id, ;
Table1 LEFT JOIN Table3 ON Table1.Cust_id = Table3.Cust_id ;
WHERE Table1.Cust_id > 1000 INTO CURSOR JUNK ORDER BY Table1.Cust_id
Is this correct and if it is why is so long and if it isn't what is the syntax for this join used
All comments will apreciate
Thank's in advance
Rocky boy...
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