sql问题

[chenwm]

我有两个sql语句

如分别为
select a.aa,sum(b.bb) from a,b where ？？？
select ta.aaa,sum(tb.dd) from ta,tb where ???
我想变为select a.aa,sum(b.bb),sum(tb.dd) from ?????
我记得好象这样
select * from (select a.aa,sum(b.bb) from a,b where ？？？
),(select ta.aaa,sum(tb.dd) from ta,tb where ???)
where a.aa=ta.aaa
可是不行，我错在哪，？
thanks

[ice2water]

看不清

[shahand]

union all可以满足你的要求

[dotnba]

同意 shahand(有志青年)

[pbsql]

where a.aa=ta.aaa肯定不对了

[iclt]

您是不是药性达到下面的效果？没看懂您的意思，只能猜测了！：）
select a.aa as aa ,sum(b.bb) as bb from a,b where ？？？
union
select ta.aaa as aa ,sum(tb.dd) as dd from ta,tb where ???