Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ODBC outer joins

ODBC outer joins

From: Kjetil Inge Bakkan <kjetilb_at_onix.no>
Date: 1997/06/04
Message-ID: <01bc7103$25657d20$0203a8c0@ONIX_00>#1/1

Oracle's ODBC drivers seems to support ANSI join syntax for at least one outer join:

SELECT *

FROM { OJ		ALL_TABLES		T
LEFT OUTER JOIN	ALL_TAB_COLUMNS	C	ON T.TABLE_NAME = C.TABLE_NAME }

Has anyone managed to outer join many tables with the ANSI syntax ?

Kjetil Received on Wed Jun 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US