Sergey S. Kostyliov writes: > >Description: > Query with INNER JOIN return 0 rows, but the same query + yet another > WHERE condition return 1 row > >How-To-Repeat: > Query: > SELECT orders_common.vendor_id > FROM orders_common > INNER JOIN orders_common_count > ON (orders_common.id=orders_common_count.orders_id) > WHERE orders_common_count.clients_names_id in (3639) > AND orders_common.vendor_id=95 > Result - 0 rows > but, > SELECT orders_common.vendor_id > FROM orders_common > INNER JOIN orders_common_count > ON (orders_common.id=orders_common_count.orders_id) > WHERE orders_common_count.clients_names_id in (3639) > AND orders_common.vendor_id=95 > 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 ... -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ 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