Seeking a basic sql

xiangjieray

table a,b,c


a column da,name in the table
b column in table da,acc
c column acc,je

Among them, column da of table a = column da of table b
acc column of table b = acc column of table c

Want now

a.da,a.name ,sum(c.je) such a result

Such as


001 three 100
002 Li Si 87
003 King Five 94
...
...
...

Please expert advice. How to write this sql
Thank you.

michealhenry

select a.da,a.name ,sum(c.je)
from a inner join b on a.da = b.da
       inner join c on b.acc = c.acc

zeonic

select a.da,a.name ,sum(c.je)
from a
left join b on a.da = b.da
left join c on c.acc = b.acc

cv4bf5d65fd

select a.da,a.name ,sum(c.je)
from a, b, c
where a.da = b.da and b.acc = c.acc

3972500

select a.da,a.name ,sum(c.je) as je
from a inner join b on a.da = b.da
       inner join c on b.acc = c.acc

xiangjieray

I have tried the grammar of the eldest brothers upstairs
a.da is invalid in the select list because the column is not included in the aggregate function. And there is no group by statement

(Note, a is a view, and a view contains da column)

zeonic

select a.da,a.name ,sum(c.je)
from a
left join b on a.da = b.da
left join c on c.acc = b.acc
group by a.da,a.name

lawn616

select a.da, a.name, T1.je from
a inner join
(
select b.da, sum(c.je) as je
from b inner join c on b.acc = c.acc group by b.acc, b.acc
) AS T1
on a.da = T1.da

五厘米空间

select a.da,a.name,sum(c.je)
from a ,b ,c
where a.da = b.da and b.acc = c.acc

五厘米空间

select a.da,a.name,sum(c.je)
from a ,b ,c
where a.da = b.da and b.acc = c.acc
group by a.da,a.name