On Monday 03 February 2003 13:31, Ciprian Trofin wrote: > I am using MySQL 3.23.47-nt on Windows 2000 Pro SP3;
[skip] > Now, the problem: > > This doesn't work: > SELECT R.id, U.user FROM ring R, users U WHERE R.user = U.id; > > id user > ------------- > 4 0 > 1 0 > 3 0 > 5 0 > 2 0 > > > This works: > SELECT R.id, U.user FROM users U, ring R WHERE R.user = U.id; > > id user > ----------- > 1 gogu > 2 alex > 3 gogu > 4 cip > 5 gogu > > > I guess it is some sort of conflict, although it shouldn't be. Could you upgrade MySQL server and then test these queries? I tested your example on 4.0.9 and both queries work fine for me: mysql> SELECT R.id, U.user FROM ring R, users U WHERE R.user = U.id; +----+------+ | id | user | +----+------+ | 4 | cip | | 1 | gogu | | 3 | gogu | | 5 | gogu | | 2 | alex | +----+------+ 5 rows in set (0.00 sec) mysql> SELECT R.id, U.user FROM users U, ring R WHERE R.user = U.id; +----+------+ | id | user | +----+------+ | 1 | gogu | | 2 | alex | | 3 | gogu | | 4 | cip | | 5 | gogu | +----+------+ 5 rows in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
