Re: OUTER JOIN !!!!

Posted in 1996

Jleblanc@vnet.ibm.com — 21 Nov 1996 16:11:50 GMT — source: Informix-list mailing list archive (1991-1998)

In <329377CD.772B@ece.uci.edu>, Remzi Oten <oten@ece.uci.edu> writes: >Hi, >If your SQL server does not do outer joins but you need to combine >tables using the outer join method what should you do to substitute ? >I'll appreciate any kind of comments. Thank you ?-- >_________________________ >REMZI OTEN >UNIV. OF CALIFORNIA, IRVINE >ECE DEPT. >Tel:(714)824-2917 (lab) > (714)509-0878 (home) >_________________________ Hi: In DB2 2.1, outer joins can be done using the set operator UNION. Examples of this can be found in the admin guide which is available from ftp.software.ibm.com dir: ps/products/db2/info The file is available as an .inf (view program) or .ps (postscript) Admin.zip (postscript), Admini.zip (inf) The outer join should be a part of ver 3.0 as other products in the Common database line (DB2 6000) have it but until it's announced we don't know for sure. Jim LeBlanc IBM DB2 Universal Database Support IBM Toronto Lab, Toronto, ON, Canada