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 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 (
