ANSI join syntax and Oracle 8i

2003-12-21 Thread Grant Allen
Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the

Re: ANSI join syntax and Oracle 8i

2003-12-21 Thread Jonathan Gennick
Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, GA etc.) was backported to 8i? No, it was not. Best regards, Jonathan Gennick --- Brighten the corner where you are

RE: ANSI join syntax and Oracle 8i

2003-12-21 Thread Grant Allen
-Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Monday, 22 December 2003 11:59 To: Multiple recipients of list ORACLE-L Subject: Re: ANSI join syntax and Oracle 8i Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does

Re: ANSI join syntax and Oracle 8i

2003-12-21 Thread Mogens Nørgaard
I don't, but perhaps Lex does? He's crazy about that Join stuff and even has a whole one-day class on mathematical methods in SQL. Also, he has written a book on SQL, that still sells well - but it's in Dutch, so you'd have to learn that language first :). Lex - welcome to the Oracle-L list