<![CDATA[Latest posts for the topic "outer join problem"]]> http://forums.enterprisedb.com/posts/list/7.page JForum - http://www.jforum.net outer join problem
create table t2 (col1 int) replicated;

select * from t1
left join t2 on t2.col1 = t1.col1
where t2.col1 is null

Error:
SQLException: ERROR: Can not prepare request: null
]]> http://forums.enterprisedb.com/posts/preList/1539/5389.page http://forums.enterprisedb.com/posts/preList/1539/5389.page GMT Re:outer join problem I suspect you have an old version of GridSQL. The outer join query works fine with the latest code from the CVS.

--
Atul]]> http://forums.enterprisedb.com/posts/preList/1539/5391.page http://forums.enterprisedb.com/posts/preList/1539/5391.page GMT