mysql子查询返回多于1行_mysql子查询返回多于1行查询错误

我有许多邮件系统表。但我不能发送查询到MySQL。mysql子查询返回多于1行查询错误

SELECT

messages_list.IDUSER,

messages_list.IDPAGE,

messages_list.IDUSER,

messages_list.v_readed,

messages_list.IDUSER,

messages_texts.v_text,

messages_texts.v_time,

messages_subjects.v_title,

user_photos.v_photoURL,

user.v_sex,

(SELECT IDPHOTO FROM user WHERE messages_list.IDUSER)

FROM

messages_texts,

user

INNER JOIN user_photos ON user_photos.ID=user.IDPHOTO AND user_photos.v_active='1'

INNER JOIN messages_list ON messages_list.IDUSER=717306 AND messages_list.v_active='1'

INNER JOIN messages_subjects ON messages_list.IDSUBJECT=messages_subjects.ID

INNER JOIN messages_users ON messages_users.IDSUBJECT=messages_subjects.ID AND messages_users.IDUSER=user.ID

WHERE

messages_users.IDUSER<>717306

GROUP BY messages_subjects.ID

ORDER BY messages_list.ID

)\n: (Subquery returns more than 1 row)

问题在哪里？

2014-03-13

formedya