0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

--select q.Id,q.Body, a.Id,a.Body,q.CreationDate, q.Score
--,q.ViewCount,q.Title, q.AnswerCount, 
--q.CommentCount,q.FavoriteCount

select * from Posts as a , 
 (select * from Posts where tags like '%youtube-api%' and PostTypeId like '1') q 
 where a.ParentId = q.Id -- q is the parent (questions) and a the answers

fork query

edited jan 24

created jan 24 jon.doe34463