drop table x;
drop table y;
create table x(a int, b int);
insert into x values(2, 1);
insert into x values(5, 1);
create table y(a int, b int);
insert into y values(1, 1);
insert into y values(2, 1);
insert into y values(3, 1);
insert into y values(4, 1);
-- query returns 1 row, but it should be returning 2 rows
select count(*) from x left outer join y on (x.a = y.a);
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
