Re: Simple SQL?

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