| Subject | R: [firebird-support] 1 a n relationship with GROUP BY conditioned on master |
|---|---|
| Author | P-Soft - Codebue Fabio |
| Post date | 2011-12-07T16:03:29Z |
I have 2 tables
A
fields a1, a2, a3
B
Fields b1 ,b2, b3, b4
I need to create a SQL retrieve sum(b3) and aggregate on b2 and filter on a2 where a1=b1
Some idea?
Codebue Fabio
.--------------------------------.
P-Soft di Codebue Fabio
via Nuova, 9
24060 Tavernola B.sca - BG
Web : www.p-soft.biz
EMail: f.codebue@...
A
fields a1, a2, a3
B
Fields b1 ,b2, b3, b4
I need to create a SQL retrieve sum(b3) and aggregate on b2 and filter on a2 where a1=b1
Some idea?
Codebue Fabio
.--------------------------------.
P-Soft di Codebue Fabio
via Nuova, 9
24060 Tavernola B.sca - BG
Web : www.p-soft.biz
EMail: f.codebue@...