例如 :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查询结果多于一行
原文:http://www.cnblogs.com/wgb123/p/6844855.html