Re: Simple SQL?

From: Isaac Blank <izblank_at_yahoo.com>
Date: Fri, 18 May 2001 18:19:23 -0700
Message-ID: <eSjN6.187$c23.162226@news.pacbell.net>

J.,

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.

Isaac

"JRStern" <JRStern_at_gte.net> wrote in message news:3b0478b4.33222561_at_news.gte.net...
> On Thu, 17 May 2001 09:38:42 -0700, "Isaac Blank" <izblank_at_yahoo.com>
> wrote:
> >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 Fri May 18 2001 - 20:19:23 CDT