首页 > 代码库 > Subquery returns more than 1 row查询结果多于一行

Subquery returns more than 1 row查询结果多于一行

例如 :WHERE(" use_id =(select user_id from store_staff where store_id="+ store_id + ")");
 
改为  WHERE(" use_id =any(select user_id from store_staff where store_id="+ store_id + ")");

Subquery returns more than 1 row查询结果多于一行