请教大师们,一个错误语句帮忙修正下

来源:百度知道 编辑:UC知道 时间:2024/06/01 17:04:25
select * from q_questionid in(select a_Questionid from tb_Answer where a_Memberid=148244) and q_Memberid=148244

没有where
应该这样
select * from q_questionid where
字段名字(例如q_Questionid) in (select a_Questionid from tb_Answer where a_Memberid=148244) and q_Memberid=148244

什么in啊?总有个字段名吧?in前边少东西

and q_Memberid=148244
是否应该放在括号里面