mysql包含in的嵌套查询,先查出包含字段的结果集,然后in查询
SELECT * from t_d_user_info where name in (select t.name from t_d_class t left join t_d_class1 a on t.name=a.name where t.postname = '改错' and t.state='正处理' )
mysql包含in的嵌套查询,先查出包含字段的结果集,然后in查询
SELECT * from t_d_user_info where name in (select t.name from t_d_class t left join t_d_class1 a on t.name=a.name where t.postname = '改错' and t.state='正处理' )