Select b.User_Name,c.User_Name,a.Message_title From Message a Join UserInfo b on a.From_id = b.User_id Join UserInfo c on a.To_id = c.User_id
select fromuser.username , touser.username from message , userinfo fromuser , userinfo touser where message.from_id = fromuser.user_id and message.to_id = touser.user_id 比较喜欢这种写法 光说不练之龙飞虎
select *,(select [USER_NAME] from userinfo where [USER_ID]=message.FROM_ID) FROM_NAME (select [USER_NAME] from userinfo where [USER_ID]=message.TO_ID) TO_NAME from message
From Message a
Join UserInfo b on a.From_id = b.User_id
Join UserInfo c on a.To_id = c.User_id
from message , userinfo fromuser , userinfo touser
where message.from_id = fromuser.user_id and
message.to_id = touser.user_id 比较喜欢这种写法
光说不练之龙飞虎
(select [USER_NAME] from userinfo where [USER_ID]=message.TO_ID) TO_NAME from message