ตอบ ไม่จำเป็นต้องใช้ทุกตารางครับ
answered.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT p.AnswerCount, p.Body, p.Title, p.CreationDate, p.Score, p.ViewCount, u.LastAccessDate, u.CreationDate, u.ProfileImageUrl, u.AboutMe, u.Location, u.WebsiteUrl, u.Reputation, u.Views, v.BountyAmount, t.TagName FROM Posts AS p LEFT JOIN Users AS u ON p.OwnerUserId = u.Id LEFT JOIN Votes AS v ON p.Id = v.PostId LEFT JOIN PostTags AS pt ON p.Id = pt.PostId LEFT JOIN Tags AS t ON pt.TagId = t.Id WHERE NOT p.DeletionDate IS NULL AND NOT p.ClosedDate IS NULL