Hi Rick, > please show the REAL output from your query and what it should REALLY look > like
table1: id|no 1|1 2|1 table2: id|no 1|1 1|1 table3: id|no 1|1 1|1 1|1 using: SELECT DISTINCT(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 gives: test|tot|SUM(table3.no) 1|6|6 2|0|0 and i want to have: test|tot|SUM(table3.no) 1|2|3 2|0|0 Tnx, Bas ----- Original Message ----- From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Bas Jobsen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 02, 2001 11:11 PM Subject: RE: [PHP-DB] Howto make a double LEFT JOIN > 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] > -- 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]
