假如现在有以下4张表
MoodContent --心情内容表
(
MoodID ,
MoodContent ,
) UserMood --用户心情表
(
UserID ,
MoodID ,
)
UserInfo --用户信息表
(
UserID ,
UserName ,
UserEmail ,
) GroupMember --群成员表
(
GroupID int,
UserID int,
)我要从这四个表中写一条查询语句,查询出 UserName , MoodContent 请问这条查询语句怎么写???
MoodContent --心情内容表
(
MoodID ,
MoodContent ,
) UserMood --用户心情表
(
UserID ,
MoodID ,
)
UserInfo --用户信息表
(
UserID ,
UserName ,
UserEmail ,
) GroupMember --群成员表
(
GroupID int,
UserID int,
)我要从这四个表中写一条查询语句,查询出 UserName , MoodContent 请问这条查询语句怎么写???
where a.MoodID=b.MoodID
inner join UserInfo B on A.UserID =B.UserID
inner join MoodContent C on C.MoodID =A.MoodID
????
where a.UserID=b.UserID and b.MoodID=c.MoodID
如果我想根据 GroupID 来查询该群成员的UserName , MoodContent 查询语句怎么写????
select a.UserName,b.MoodContent
from UserInfo a,UserMood b, MoodContent c,GroupMember d
where a.UserID=b.UserID and b.MoodID=c.MoodID and a.UserID=d.UserID
and d.GroupID=@GroupID
inner join UserMood A on D.UserID =A.UserID
inner join UserInfo B on A.UserID =B.UserID
inner join MoodContent C on C.MoodID =A.MoodID
inner join UserMood A on D.UserID =A.UserID
inner join UserInfo B on A.UserID =B.UserID
inner join MoodContent C on C.MoodID =A.MoodID
where D.GroupID='你的条件'
a.UserName,b.MoodContent
from
UserInfo a,UserMood b, MoodContent c,GroupMember d
where
a.UserID=b.UserID
and
b.MoodID=c.MoodID
and
a.UserID=d.UserID
and
d.GroupID=@GroupID
from MoodContent
join UserMood on MoodContent.MoodID=UserMood.MoodID
join UserInfo on UserInfo.UserID=UserMood.UserID
join GroupMember on GroupMember.UserID=UserInfo.UserID
where GroupID=你输入的值