I've got the following query:
<snip> select oafs.person.*, oafs.biography.*, oafs.address.position1 from oafs.person left join oafs.biography on oafs.person.person_id = oafs.biography.person_id left join oafs.address on oafs.biography.person_id = oafs.address.person_id where oafs.address.preferred = 'true' and oafs.person.person_id in ( '2140', '2139', '2136', '934', '1', '347', '1733', '1129', '1864' ) order by field(oafs.person.person_id, '2140', '2139', '2136', '934', '1', '347', '1733', '1129', '1864' ) </snip> This runs fine on my local XP box. However, when I try to run it on our production Sun machine, it executes the query and returns the correct results EXCEPT it pays no heed to the "order by" portion, i.e. it orders by the person_id asc rather than the specifc order indicated. Like I said, works fantastic on the XP machine. The tables are identical on both machine regarding structure and content. And I know that the "order by field" functionality works on the production machine because I've tested it with simpler queries. Any suggestions would be greatly appreciated!! -m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
