select (select id from a where user_id=b.id),b.* from b ;--这个能正常得到结果
select (select a.id from (select id from a where user_id=b.id) a),b.* from b;--这个会报Unknown column 'b.id' in 'where clause'
...全文
7017打赏收藏
mysql嵌套子查询的问题
一层子查询可以正确得到结果,多层嵌套子查询报错。有没有其他写法,可以避免报错 select (select id from a where user_id=b.id),b.* from b ;--这个能正常得到结果 select (select a.id from (select id from a where user_id=b.id) a),b.* from b;--这个会报Unknown column 'b.id' in 'where clause'