Simple SQL?

Hi,
is there a 'simple' SQL-statement for the following problem?

I have 3 tables

Tbl a
a
1

Tbl b
b1 b2

1      1
1      2

Tbl c
c1 c2
1 3
1 4
1 5

Relationen
a -->> b
a -->> c

and I want
a sum(b) sum(c)

in ONE row:

a sum(b2) sum(c2)

1    3                12

Does anyone have a clue?

Thank You,

Stefan Peschke Received on Thu May 17 2001 - 16:18:42 CEST