Re: SQL Problem

Posted in 1997

Thomas Tatum — 14 Dec 1997 15:43:25 -0500 — source: Informix-list mailing list archive (1991-1998)

>>>>> "Scott" == Scott Black <sblack@elsouth.com> writes: Scott> Try: select a.column from table a, outer abc b where Scott> a.col_name != b.col_name; Notice the 'outer'. This says Scott> that if you don't find a row in table b select the row from Scott> table a anyway. If you dont use OUTER, its a cartesian product and 0 x something is 0.