Re: Use of upper keyword in outer join...

From: <shiling_at_math.wayne.edu>
Date: Mon, 31 May 1999 15:26:58 GMT
Message-ID: <7iu9o2$gsp$1@nnrp1.deja.com>

Try,

where upper (a.emp_id ) = upper (b.emp_id (+))

In article <7itdad$gr0$1_at_nickel.uunet.be>, "Bart Van Havere" <barhav_at_softcell.be> wrote:
> Hi all,
>
> I have a 'small' problem with the SQL syntax. When I use the keyword
upper
> in a whereclause when that field is used in a outer join, the I get
the
> error that the SQL statement is not properly ended (he doesn't want to
go
> further than the '(' of the outer join keyword). Have I done something
rong
> here or is this feature not supported :(
>
> Bart
> barhav_at_softcell.be
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon May 31 1999 - 10:26:58 CDT