会员ID:UserID=Request("UID")有以下三个信息评论表:A新闻评论表字段:ID,A_UserID,NewsID,A_Time,A_ContentB文章评论表字段:ID,B_UserID,ArticleID,B_Time,B_ContentC产品评论表字段:ID,C_UserID,PID,C_Time,C_Content问题:
在会员中心有一栏目是显示该会员参与点评的信息,怎么才能通过一条SQL语句查询以上表显示该会员参与的点评信息,显示以下字段信息:
评论方题的ID
评论的时间
评论的内容
在会员中心有一栏目是显示该会员参与点评的信息,怎么才能通过一条SQL语句查询以上表显示该会员参与的点评信息,显示以下字段信息:
评论方题的ID
评论的时间
评论的内容
From A where A.A_UserID=@UserID
union allselect B.ID,B_Time
From B where B.B_UserID=@UserIDselect C.ID,C_Time
From C where C.C_UserID=@UserID
union all
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281
select ID , A_Time , A_Content from A
union
select ID , B_Time , B_Content from B
union
select ID , C_Time , C_Content from C
) t
select a.uid,a.会员名称,b.字段,c.字段,d.字段 from 会员表 a join A新闻 b
on a.uid=b.A_userid
join B文章 c on a.uid=c.b_userid
join c产品 d on a.uid=d.c_userid
a.uid,a.会员名称,b.字段,c.字段,d.字段
from
会员表 a join A新闻 b
on
a.uid=b.A_userid
join
B文章 c on a.uid=c.b_userid
join
c产品 d on a.uid=d.c_userid
from (
select ID,A_UserID as userid,NewsID as TID,A_Time as [Time],A_Content as Content from A
union all
select ID,B_UserID as userid,ArticleID as TID,B_Time as [Time],B_Content as Content from B
union all
select ID,C_UserID as userid,PID as TID,C_Time as [Time],C_Content as Content from C)T
where userid = @userID