Hi,
I uploaded the file innerjoin.tar to
ftp://support.mysql.com/pub/mysql/secret.
please reject my first attemp with name "innerjoinbug.tar" (problems
with kde :-( )
Please let me know if I can be of further help.
Thank you guys,
I think you are doing a wonderful job!
Best re
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 (
Hi!
> "Sergey" == Sergey S Kostyliov <[EMAIL PROTECTED]> writes:
>> Description:
Sergey> Query with INNER JOIN return 0 rows, but the same query + yet another
Sergey> WHERE condition return 1 row
>> How-To-Repeat:
Sergey> Query:
Sergey> SELECT orders_common.vendor_id
Sergey>
>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.o
