Hi, > > AND and orders_common.id=1060340 > > Result - 1 row > > You have two AND's one after another. > > Try with one AND and tell us what you get ... Two AND is a typo Real query has only one AND
I'll send full test case via ftp in a one hour Best Regards, Sergey S. Kostyliov <[EMAIL PROTECTED]> --------------------------------------------------------------------- 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