0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT Posts.Id, 
      MONTH(CreationDate) AS postmonth, 
      YEAR(CreationDate) AS postyear,
      PostTags.*,
      Tags.Id,
      Tags.TagName
FROM Posts, PostTags, Tags
WHERE
  PostTags.PostId = Posts.id AND PostTags.TagId = Tags.id

fork query

edited jul 30 13 ranman

created apr 16 13 jon.doe10959