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: phil.oelkers_at_ripco.com <phil.oelkers_at_experian.com>
Date: 18 May 2001 07:29:26 -0700
Message-ID: <cd616281.0105180629.52579044@posting.google.com>

Stefan

This should work in db2/udb

Hope it helps

Regards


Select

           t1.a,
           sum(t2.b2),
           sum(t3.c2)
from
        a t1 left outer join
        b t2
on     t1.a1 = t2.b1         left outer join
        c t3
on     t1.a1 = t3.c1

group by t1.a1
order by t1.a1
; Received on Fri May 18 2001 - 09:29:26 CDT

Original text of this message

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