Re: Weird ORDER BY problem with PHP an MS ACCESS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux