Hi All,
I am using Alpha M , Left outer join not working in v1.7.2, Please see
below.
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);
-- select query returns 1 row, but it should be returning 2 rows.
select count(*) from x left outer join y on (x.a = y.a);
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
