Constantin Wolber wrote:
SELECT table1.col1,
table1.col2,
table2.col1,
table3.col1,
table3.col2
FROM (table1
LEFT OUTER JOIN table2
ON table1.fkcol=table2.idcol)
LEFT OUTER JOIN table3
ON table1.fkcol2=table3.idcol
WHERE table2.idcol=id
ORDER BY table2.col1,table1.col2
The result isn't sorted anymore, I just don't know why this can happen.
Ok seems like te solution ist to change the where clause from
table2.idcol to table1.fkcol.
Don't really know what the difference is, but it works for me.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
