Re: A (+) in the where clause

From: Paul Beardsell <paul_at_hoxton.demon.co.uk>
Date: Sat, 21 Aug 1993 11:02:29 +0000
Message-ID: <745930949snz_at_hoxton.demon.co.uk>


In article <23m3jdINNh4j_at_cronkite.cisco.com> pkane_at_cisco.com writes:

>It's called an outer join. It returns values even if the match
>referred to by the outer join fails. I don't see much point in
>doing an outer join with a one table select statement...

Well, X (+) = "VALUE" could have been implemented as "equals or is null".

-- 

Paul Beardsell                          21 Finn House, Bevenden St, HOXTON,
~~~~~~~~~~~~~~                          Hackney, London, N1-6BN, UK.
paul_at_hoxton.demon.co.uk
pbeardsell_at_cix.compulink.co.uk          (+44 or 0)71 608-2391
Received on Sat Aug 21 1993 - 13:02:29 CEST

Original text of this message