Outer join question

Posted in 1998

Guillermo Labatte — Fri, 13 Feb 1998 10:28:10 -0300 — source: Informix-list mailing list archive (1991-1998)

Hi, I'm using Online 5.07 I issue the command ... select * from table_A,outer table_B where table_A.x=table_B.y into temp table_C; select * from table_C where y is null and it returns a different result from select * from table_A,outer table_B where table_A.x=table_B.y and table_B is null; Why?