Re: OUTER JOIN question

Posted in 1998

Nick Leporacci, Jr. — Fri, 6 Mar 1998 10:30:44 -0500 — source: Informix-list mailing list archive (1991-1998)

Check out the syntax for the UNION statement. This will very easily allow you to do what you're asking. Reiner Kunz wrote in message <6dn83q$n54$3@goof.de.uu.net>... >Hi, > >I have two tables of the same structure. I want to select all records from >the second table which do not appear in the first table. How Do I do this >with an OUTER JOIN? Or is there another way? > >Then I want to write the found records in a third table for further >analysis. Many thanks for your help! > >-- >cu Reiner > >