Re: Simple SQL?

On Mon, 21 May 2001 13:21:52 -0700, "Isaac Blank" <izblank_at_yahoo.com> wrote:

>"JRStern" <JRStern_at_gte.net> wrote in message
>news:3b097785.8427888_at_news.gte.net...
>> On Mon, 21 May 2001 12:27:31 -0700, "Isaac Blank" <izblank_at_yahoo.com>
>> wrote:
>> >Try re-writing the SELECT I originally posted using joins.
>>
>> It's wordy.
>
>So what? Go ahead and do it!
 

>SELECT a,
> (SELECT SUM(b2) from Tblb WHERE Tbla.a=Tblb.b1),
> (SELECT SUM(c2) from Tblc WHERE Tbla.a=Tblc.c1)
>FROM Tbla

select a,
  (select sum(Tblb.b2) from

     Tbla inner join Tblb on Tbla.a=Tblb.b1),   (select sum(Tblc.c2) from

     Tbla inner join Tblc on Tbl1.a=Tblc.c1) from Tbla

Is there a point?

Well, sure there's a point -- no where clause.

Please remit payment to the above email address.

J. Received on Sun Jul 22 2001 - 01:25:15 CEST