mysql Subquery returns more than 1 row(サブクエリは1行以上を返す)ソリューション
335 ワード
mysql Subquery returns more than 1 row(サブクエリは1行以上を返す)ソリューション
SELECT * FROM score se WHERE se.sid=(SELECT sea.sid FROM score sea)
SELECT * FROM score se WHERE se.sid=ANY(SELECT sea.sid FROM score sea)
SELECT * FROM score se WHERE se.sid=SOME(SELECT sea.sid FROM score sea)
SOME ANY