http://forums.enterprisedb.com/posts/list/7.page JForum - http://www.jforum.net create table t2 (id int);
insert into t1 values (1);
select * from t1 left join t2 on t2.id = 0;

Result:

no rows to display

Expected:

1, null
]]> http://forums.enterprisedb.com/posts/preList/1562/5458.page http://forums.enterprisedb.com/posts/preList/1562/5458.page GMT
Regards,

Mason Sharp]]> http://forums.enterprisedb.com/posts/preList/1562/5469.page http://forums.enterprisedb.com/posts/preList/1562/5469.page GMT