General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Multiple left outer join problem
ok here is my code
SELECT QUOTATIONS.DATE_RATES AS DATE_RATES,;
QUOTATIONS.IDQUOTATIONS AS IDQUOTATIONS,;
CLIENT.NAME,;
QUOTATIONS.STATUS,;
QUOTATIONS.TYPE_DE_QUOTATION,;
SERVICE.TYPE AS TYPE_DE_SERVICE,;
QUOTATIONS.CONTACT_ID AS CONTACT_ID,;
QUOTATIONS.DEPART AS DEPART,;
QUOTATIONS.ARRIVER AS ARRIVER;
FROM QUOTATIONS;
LEFT JOIN CLIENT CLI ON (CLIENT.IDClient = QUOTATIONS.CLIENT_ID) ;
LEFT OUTER JOIN SERVICE SER ON (QUOTATIONS.TYPE_DE_QUOTATION=; service.IDSERVICE)
but it doest work why ?
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