SEO

#1 (**permalink**) 02-26-2008, 02:45 PM

Hi

I have the following Oracle query and needs to be re-written in DB2.
Seems DB2 doesn't support OUTER JOIN symbols like (+). Can anyone help
me..

SELECT A.FIELD_VALUE, B.FIELD_VALUE FROM TABLEA A, TABLEB B WHERE
(A.FIELD_NAME='Test') AND B.FIELD_NAME (+) = A.REF

Thanks

#2 (**permalink**) 02-26-2008, 02:45 PM

On 10 Sep 2003 09:52:48 -0700, venkatprakash@hotmail.com (Prakash)
wrote:

>Hi
>
>I have the following Oracle query and needs to be re-written in DB2.
>Seems DB2 doesn't support OUTER JOIN symbols like (+). Can anyone help
>me..
>
>SELECT A.FIELD_VALUE, B.FIELD_VALUE FROM TABLEA A, TABLEB B WHERE
>(A.FIELD_NAME='Test') AND B.FIELD_NAME (+) = A.REF

(+) is Oracle-specific syntax (and it is being phased out as of
version 9 already). DB2 supports the standard SQL join syntax (LEFT
[OUTER] JOIN, RIGHT [OUTER] JOIN, INNER JOIN, etc.).

--
Bob Hairgrove
rhairgroveNoSpam@Pleasebigfoot.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

DB2 join