举个例子
1.这样就会出现问题
select a from t1 where a in (select b from t2 )
只要在子查询的后面加个别名就可以了。改成select a from t1 where a in (select b from t2 ) b就可以了。
举个例子
1.这样就会出现问题
select a from t1 where a in (select b from t2 )
只要在子查询的后面加个别名就可以了。改成select a from t1 where a in (select b from t2 ) b就可以了。