1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT 
  P.Id, P.Title, P.PostTypeId, P.Body, P.ViewCount, P.Score, P.Tags, P.CreationDate,
  a.Id, a.Body

FROM 
  Posts as P
  JOIN Posts as a ON P.Id = a.ParentId
  
WHERE
  P.Tags like '%ethic%'
  OR
  P.Title LIKE '%ethic%'
  OR
  P.Body LIKE '%ethic%'
  OR
  a.Body LIKE '%ethic%'

ORDER BY 
  P.Id DESC

fork query

edited apr 13

created apr 13 jon.doe38611