追梦人.Net学习日记

摘要： 如何如何....对为空的表.列不做要求,就用内联接!! SELECT u.[user_name],u.[user_address],u.[user_qq],u.[user_homepage],u.[user_headimg],u.[user_addtime],g.[GuestName] ,g.[GuestFace],g.[GuestClientIP],g.[GuestTitle],g.[GuestText],g.[GuestMsgHide],g.[GuestGetTime],g.[GuestValidate] ,r.[replyText],r.[replyTime] From zmguestbook g LEFT JOIN zmuserinfo u ON g.[user_name]=u.[user_name] LEFT JOIN zmguestbookreply r ON g.[GuestID]=r.[GuestID] ORDER BY g.[GuestID] DESC 阅读全文