0

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 TOP 10
  q.Score as [QScore],
  q.Id as [Post Link],
  q.Title,
  q.Tags,
  q.Body as [Question Body],
  q.OwnerUserId as [Questioner],
  a.Score as [AScore],
  a.Body as [Answer Body],
  a.CreationDate as [AnswerDate]
FROM
  Posts as q
    Join Posts as a
      on a.ParentId = q.Id
WHERE
  q.Body LIKE '%visa%' OR
  q.Body LIKE '%immigration%';

fork query

edited oct 24

created oct 23 jon.doe46100