三张表 t_user,t_message,t_messagetouser
t_user中有UserId(键)、UserName字段
t_message中有MessageId(键)、MessageTitle、MessageDate字段
t_messagetouser中有MessageId(键)、UserID查询出MessageTitle、UserName、MessageDate的SQL语句怎么写?
急用额
t_user中有UserId(键)、UserName字段
t_message中有MessageId(键)、MessageTitle、MessageDate字段
t_messagetouser中有MessageId(键)、UserID查询出MessageTitle、UserName、MessageDate的SQL语句怎么写?
急用额
select MessageTitle,UserName,MessageDate from t_messagetouser a inner join t_message b on a.MessageId=b.MessageId inner join t_user c on a.UserID=c.UserID
from t_user t1,t_message t2,t_messagetouser t3
where t1.UserId = t3.UserId and t3.MessageId = t2.MessageId
MessageTitle,UserName,MessageDate
from
t_messagetouser a inner join t_message b
on
a.MessageId=b.MessageId inner join t_user c on a.UserID=c.UserID
from t_message a inner join t_messagetouser b on a.MessageId=b.MessageId
inner join t_user c on b.UserId=c.Userid