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 p.Id, p.OwnerUserId, p.Title, p.Body, p.CreationDate, p.LastActivityDate, p.Score, p.ViewCount, p.AnswerCount, p.AcceptedAnswerId, p.CommentCount, p.FavoriteCount, p.Tags, u.DisplayName 
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
  WHERE PostTypeId = 1 AND 
   Title LIKE '%AI%' ;

fork query

edited may 25

created may 25 jsh