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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Simple SQL?

Re: Simple SQL?

From: JRStern <JRStern_at_gte.net>
Date: Sun, 20 May 2001 03:11:57 GMT
Message-ID: <3b0736ba.40625596@news.gte.net>

On Fri, 18 May 2001 18:19:23 -0700, "Isaac Blank" <izblank_at_yahoo.com> wrote:
>I would be glad to use ANSI syntax for joins - but there is no joins to
>apply this syntax to. What you see here is a (relatively) simple SELECT
>statement with correlated subqueries in the SELECT list. Similar to a join,
>but not quite the same.

There are multiple tables mentioned, there are joins going on.

J.

>> >SELECT a,
>> > (SELECT SUM(b2) from Tblb WHERE Tbla.a=Tblb.b1),


                                        ^^^^^^^^^^^^^^^

>> > (SELECT SUM(c2) from Tblc WHERE Tbla.a=Tblc.c1)


                                       ^^^^^^^^^^^^^^^^


>> >FROM Tbla
>>
>> Doesn't anybody use ANSI join syntax??????
>>
>> J.
Received on Sat May 19 2001 - 22:11:57 CDT

Original text of this message

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