Re: Simple SQL?

From: phil.oelkers_at_ripco.com <(phil.oelkers_at_ripco.com)>
Date: 18 May 2001 07:29:26 -0700
Message-ID: <cd616281.0105180629.52579044_at_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 - 16:29:26 CEST

This message: [ Message body ]
Next message: Isaac Blank: "Re: Simple SQL?"
Previous message: Carl Rosenberger: "Re: S.O.D.A. database Query API - call for comments"
In reply to: Stefan Peschke: "Simple SQL?"
Next in thread: Isaac Blank: "Re: Simple SQL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message