mysql子查询exists
2019-06-11 本文已影响0人
末小竹
SELECT * FROM t_order a where a.user_id=5 and exists(SELECT * from t_relation b where b.userID =a.user_id)
SELECT * FROM t_order a where a.user_id=5 and exists(SELECT * from t_relation b where b.userID =a.user_id)