Re: OUTER JOIN !!!!

Posted in 1996

Jleblanc@vnet.ibm.com — 21 Nov 1996 17:26:05 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: I have to make a correction to my previous append. Although there is information on outer joins in the admin guide. There is an example of doing an outer join in the SQL Reference. This can also be found at ftp.software.ibm.com dir: ps/products/db2/info The file names are: sqlref.zip (postscript) and sqlrefi.zip (inf) Jim LeBlanc IBM DB2 Universal Database Support IBM Toronto Lab, Toronto, ON, Canada