这样的sql怎么写？

[teclogid]

有个主表，比如交易表 trade（id,name）,有个流水表 detail(id,trade_id,money)
现在我要用一条sql，查询出trade表id=x中所有字段和流水表里trade_id=x所有的money的总和，请问这样的sql怎么写？

[冷箫轻笛]

select t1.id,t1.name,sum(t2.money) as sum_money
from trade t1 ,detail t2
where t1.id = t2.trade_id and t1.id = x
group by t1.id,t2.name

[itzhiren]

select t1.id,t1.name,sum(t2.money) as sum_money
from trade t1 ,detail t2
where t1.id = t2.trade_id and t1.id = x
group by t1.id,t1.name

[teclogid]

谢谢，如果我的detail表里没有数据，那记录能显示出来吗？我希望显示出来，总金额是空或是0都可以

[liujuns]

select t1.id,t1.name,sum(t2.money) as sum_money
from trade t1 ,detail t2
where t1.id *= t2.trade_id and t1.id = x
group by t1.id,t1.name

[liangpei2008]

declare @trade table(id int,name varchar(10))
insert @trade select 1,'aaa'
union all select 2,'bbb'
union all select 3,'ccc'
--------------------------------------------
declare @detail table(id int,trade_id int,money int)
insert @detail select 1,1,30
union all select 2,1,20
union all select 3,2,20
union all select 3,2,20
--------------------------------------------
--SQL语句
select A.id,A.name,isnull(B.money,0) as money
from @trade A left join
(
select trade_id,sum(money) as money
from @detail
group by trade_id) B
on A.id=B.trade_id
where A.id=1 --条件