Hi,
On 2004-08-04 21:20, gerald_clark wrote:
[...]
SELECT C.B
FROM A
INNER JOIN C ON C.A = C.A
Perhaps you meant:
INNER JOIN C on C.A = A.A
RIGHT JOIN B ON B.B = C.B
WHERE C.B IS NULL
[...]
Yes, thanks. I didn't realize that mysqlbug sends the report to a
mailing list. I have proceeded to su
join after inner join has wrong result
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-4.0.20 (Source distribution)
Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.0.20, for pc-linux-gnu on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKo
WHERE C.B IS NULL
Expected Result:
A3
--
2
Actual Result:
A3
--
1
2
2
Tried in postgresql and it works like the expected result.
>Fix:
none
>Submitter-Id:
>Originator:Alan Tam
>Organization:
>MySQL support: none
>Synopsis: Right join after inner join ha
