> > When I run the query "select yt1_name, yt1_descr, yt2_name, > yt2_descr from > > yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id and yt2_name = > > '2-name2'" on postgres database I get the following results
Probaly if you change your postgres query to this, it will give the same answer as Oracle: select yt1_name, yt1_descr, yt2_name, yt2_descr from yuva_test1 left outer join yuva_test2 on yt1_id=yt2_id where yt2_name = '2-name2'; ?? Chris > > But when I tried the same on Oracle(8.1.7) (the query is > "select yt1_name, > > yt1_descr, yt2_name, yt2_descr from yuva_test1, yuva_test2 where > > yt1_id=yt2_id(+) and yt2_name = '2-name2'') I get the following result And maybe if you change the oracle query to this, it will give the same answer as postgres: select yt1_name, yt1_descr, yt2_name, yt2_descr from yuva_test1, yuva_test2 where yt1_id=yt2_id(+) and yt2_name = '2-name2'(+); Just guessing tho. Chris ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster