sql 语句 in 后面是字段的情况怎么处理？

[左手青春右手年华]

select a.sale_mount from Sale_Amount a,LevelRelation b where a.userid in b.levelthree_id  and b.server_id = '1'

语法是错的?

[spiritofdragon]

select sale_mount
from Sale_Amount 
where userid in
(select levelthree_id from LevelRelation where server_id = '1')

[饮水需思源]

select a.sale_mount from Sale_Amount a where a.userid in( select leveltree_id from LevelRelation b where b.server_id = '1')

[Ginnnnnnnn]

in 的用法是 select * from table where col in (1,2,3,4) 这样的 你这个情况使用 #1 #2的其中一种写法就可以

[shadowpj]

select sale_mount from Sale_Amount where userid in (select evelthree_id from ,LevelRelation where b.server_id = '1')

[中国风]

select a.sale_mount from Sale_Amount a,LevelRelation b where a.userid = b.levelthree_id  and b.server_id = '1' in要加(),你这里改为=

[中国风]

a.userid in( b.levelthree_id)--IN只能这样用

[Ekun_sky]

select a.sale_mount  from Sale_Amount as a where 
exists(select 1 from LevelRelation as b where a.userid=b.levelthree_id and 
b.server_id='1')

[myherowin]

IN后面必须要加括号