[PHP-DB] Re: Weird ORDER BY problem with PHP an MS ACCESS

[Constantin Wolber]

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