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.

>> >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