SELECT dbo.GuestNews.ID, dbo.GuestNews.Title, dbo.GuestNews.[Content], dbo.GuestNews.AddTime, dbo.GuestNews.Editor, dbo.GuestNews.OrderID,
dbo.GuestNews.TypeID, dbo.GuestNews.ImageUrl, dbo.GuestNews.SmallID, dbo.Guest.GuestName
FROM dbo.Guest LEFT OUTER JOIN
dbo.GuestNews ON dbo.Guest.GuestID = dbo.GuestNews.TypeID这个就是 典型的例子
dbo.GuestNews.TypeID, dbo.GuestNews.ImageUrl, dbo.GuestNews.SmallID, dbo.Guest.GuestName
FROM dbo.Guest LEFT OUTER JOIN
dbo.GuestNews ON dbo.Guest.GuestID = dbo.GuestNews.TypeID这个就是 典型的例子
select * from a,b where a.name=b.name;
上面两句一个意思
select * from a,b where a.name=b.name;
上面两句一个意思学习啦