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...