From Davor:
Try this:
SELECT * FROM `Quotes` LEFT OUTER JOIN `Products`
ON (`Products`.`QuoteID`=`Quotes`.`QuoteID`)
LEFT OUTER JOIN `Clientes` ON
(`Clientes`.`ClientID`=`Quotes`.`ClientID`)
WHERE `Quotes`.`QuoteID`=6936
Dundo
Still the same... :(
When a QuoteID from Quotes is not available as QuoteID from Products
the result I get gets an empty QuoteID.
It seems that it saves the QuoteID from the last table it worked with...
Should I change the order of the tables in the query?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
