如何组织SQL语句?
create table a(a decimal(18,2),c varchar(10))
select * from a
insert into a values(5.5,1)
insert into a values(4.5,1)
create table b(a decimal(18,2),b int(4),c varchar(10))
select * from b
insert into b values(2.5,2,1)
insert into b values(5,1,1)
我用的sql语句是:
SELECT sum(a.a) as Sum1,sum(b.a*b.b) as Sum2
FROM a,b
WHERE a.c = '1' AND a.c=b.c
得到:
sum1=20,sum2=20
我想取a.c=b.c=1是的sum1,sum2