please show the REAL output from your query and what it should REALLY look like
-----Original Message----- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:38 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT > JOIN table3 ON table2.id=table3.id Well, oke now i have: table1: id|no 1|1 2|1 table2: id|no 1|1 1||1 table2: id|no 1|1 1||1 1||1 The result i want tot have is: id|sum(table2.no)|sum(table3.no)| 1|2|3 2|0|0 my query: SELECT DISTINT( table1.id) AS test, SUM(table2.no) AS tot, SUM(table3.no FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT JOIN table3 ON table2.id=table3.id GROUP BY test ORDER BY tot DESC which give my something like: id|5|5| 1|2|3 2|0|0 :( ----- Original Message ----- From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Bas Jobsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 10:19 PM Subject: RE: [PHP-DB] Howto make a double LEFT JOIN > SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT > JOIN table3 ON table2.id=table3.id > > -----Original Message----- > From: Bas Jobsen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 02, 2001 3:13 PM > To: Rick Emery; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > > > > Remove the parentheses > > SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON > > table2.id=table3.id ON table1.id=table2.id > > I still got: > MySQL retourneerde: You have an error in your SQL syntax near 'LEFT JOIN > table3 ON > table2.id=table3.id ON table1.id=table2.id' at line 1 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]