SQL select 语句 ，在线等！！！！

[lilin0503]

数据库中两张表，表aa 有两列 boxid 和 sn ,其中一个boxid对应多个sn, sn是唯一的，在另一张表bb 中item ,wonum ,sn三列，我现在要根据boxid查出aa中的sn,然后将bb中的sn对应的item,wonm显示出来sql 语句如下
Select a.*,b.Item,b.WoNum From aa a inner join bb b on a.BoxID = 'Wo_box_2' and b.sn=(select sn from aa)
报错为：Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
请问sql语句该怎么写？？？？？？

[开着拖拉机泡妞]

Select a.*,b.Item,b.WoNum From aa a inner join bb b on a.BoxID = 'Wo_box_2' and b.sn in(select sn from aa)

[开着拖拉机泡妞]

子查询返回了多个值，不能用等号

[黄_瓜]

Select a.*,b.Item,b.WoNum From aa a 
inner join bb b on a.BoxID = 'Wo_box_2' 
and b.sn=a.sn

这样就可以了

[PL5240]

select a.*,b.item,b.wonum from aa as a join bb as b on a.sn=b.sn where a.boxid='Wo_box_2'

[dawugui]

Select a.*,b.Item,b.WoNum 
From aa a inner join bb b 
on a.BoxID = 'Wo_box_2' and a.sn = b.sn

[KinggridPeng]

专家正解

[哥哥大]

Select a.*,b.Item,b.WoNum From aa inner join bb as b on a.BoxID = 'Wo_box_2' and aa.sn=bb.sn

[哥哥大]

Select a.*,b.Item,b.WoNum From aa inner join bb as b on aa.BoxID = 'Wo_box_2' and aa.sn=bb.sn

[哥哥大]

Select *,b.Item,b.WoNum From aa inner join bb as b on aa.BoxID = 'Wo_box_2' and aa.sn=bb.sn


回答的第一个，第二个，我写错了，看第三个，