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 + ")");
posted @ 2017-05-12 11:50  NG柠檬  阅读(5351)  评论(0编辑  收藏  举报