0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT DISTINCT 
  p.Id,
  p.Title,
  p.Tags,
  p.Body,
  p.CreationDate
FROM 
Posts p 
INNER JOIN PostTags pt ON p.Id = pt.PostId
INNER JOIN Tags t ON pt.TagId = t.Id
WHERE
(UPPER(t.TagName) LIKE UPPER('jax'))
AND
(p.CreationDate > '2018-01-01')

fork query

edited may 17

created apr 16 dynamicwebpaige