56,679
社区成员
发帖
与我相关
我的任务
分享[Err] 1242 - Subquery returns more than 1 row
select username,nicname from appaccount where
id in (
(select otherid from friends where localid=(
select id from appaccount where username=#user# )
)
,
(select localid from friends where otherid=(
select id from appaccount where username=#user# )
)
)
为什么不能返回多条呢 求大大解惑
id in (
(select otherid from friends where localid=(
select id from appaccount where username=#user# )
)
,
(select localid from friends where otherid=(
select id from appaccount where username=#user# )
)
)
为什么不能返回多条呢 求大大解惑
...全文
请发表友善的回复…
发表回复
X战猫 2013-04-25
- 打赏
- 举报
已解决 谢谢大大
<select id="friendsList" parameterClass="String" resultMap="friendsMap">
select username,nicname from appaccount where
id in
(select otherid from friends where localid=(
select id from appaccount where username='yamma1'
)
)
or id in
(select localid from friends where otherid=(
select id from appaccount where username='yamma1'
)
)
</select>
X战猫 2013-04-25
- 打赏
- 举报
运行后返回1 与表中吻合
WWWWA 2013-04-25
- 打赏
- 举报
检查
select id from appaccount where username=#user#
返回结果
