microBlog
id userid title contentblogComments
id userid blogID infoUsers
id username password
/*以上是表结构*/
--我想查找我在别人博客上的评论,以及别人在我博客上的评论
--以下是我的sql语句,但查询内容为空,可数据库里有内容的,这是为何?
/*SELECT a.*
FROM [blogComments] a, [microBlog] b, [Users] c
where a.userid=c.id and a.blogID=b.id and b.userid=c.id and c.id=8*/
SELECT a.* FROM [blogComments] a
INNER JOIN [microBlog] b ON a.blogID = b.id
WHERE b.userid = 8
OR a.userid = 8
SELECT a.* FROM [blogComments] a
INNER JOIN [microBlog] b ON a.blogID = b.id
WHERE b.userid = 8 and a.userid = 8应该是这样的吧!