0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーとプログラミングに熱心な人々のための質問と回答

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 > '2020-01-01')

view current version

edited may 17

created apr 16 dynamicwebpaige