子查询返回值多于一个的情况!! 用SQL搞定!感谢帮助!

[loulanlouzhu]

表a:
aaa bbb
a 2
a 3
b 4
b 5

表b:
ccc ddd
a 6
b 7

想得到:
eee fff
a 6*2
a 6*3
b 7*4
b 7*5

如何用SQL搞定!?


感谢帮助!

[realgz]

select a.aaa,b.ddd+'*'+a.bbb as fff from a inner join b on a.aaa=b.ccc

[伍子V5]

select a.aaa as eee,a.bbb*b.ddd as fff from 表a a,表b b where a.aaa=b.ccc

[伍子V5]

呵呵，不知道哪种情况了

[realgz]

是不是字符类型，如果不是，变成

select a.aaaas eee ,convert(varchar(32),b.ddd)+'*'+convert(varchar(32),a.bbb) as fff from a inner join b on a.aaa=b.ccc

[txlicenhe]

select a.aaa as eee,a.bbb+'*'+b.ddd as fff from 表a a join 表b b on a.aaa=b.ccc

[loulanlouzhu]

不是字符!

是数据!算出结果的!

[loulanlouzhu]

表a:
aaa bbb
a 2
a 3
b 4
b 5

表b:
ccc ddd
a 6
b 7

想得到:
eee fff
a 6*2=12
a 6*3=18
b 7*4=28
b 7*5=35

[realgz]

二楼回答的就对了如果是要表达式那
自己改装一下

[Dennis618]

select a.aaa as eee,cast (a.bbb as int)*cast(b.ddd as int) as fff from 表1a join 表2 b on a.aaa=b.ccc

[pengdali]

select a.aaa eee,a.bbb*b.ddd fff from a,b where a.aaa=b.aaa

[loulanlouzhu]

http://expert.csdn.net/Expert/topic/2339/2339794.xml?temp=.5805323