帮我分析一句SQL，谢谢大家！

[QQKiKi]

SELECT intId,intTitle from note where intId=(select intUserId,intNoteId from fav where intUserId=$s_userId)

语法上似乎有点错误，子查询那里帮我改改

intId是要从FAV表里取出来intNoteId

[QQKiKi]

只能用 from note,fav 这种形式了

[vivianwlp]

SELECT intId,intTitle from note where intId in (select intNoteId from fav where intUserId=$s_userId)

[QQKiKi]

Warning: Supplied argument is not a valid MySQL result resource in j:\data\content.php on line 192

去掉子查询是正确的

[hnxyy]

php里不支持子查询吧

[dragonxu]

mysql不支持子查询。