0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

--select * from Posts as a , 
-- (select * from Posts where tags = 'youtube-api' and PostTypeId like '%1%') b 
--where a.ParentId = b.Id
 
 
 
-- select * from Posts where tags like '%youtube-api%' and PostTypeId like '%1%'



select q.Id,q.Body, a.Id,a.Body,q.CreationDate, q.Score
,q.ViewCount,q.Title, q.AnswerCount, 
q.CommentCount,q.FavoriteCount
from Posts as a , 
 (select * from Posts where tags like '%youtube-api%' and PostTypeId like '1') q 
 where a.ParentId = q.Id -- b is the parent (questions) and a the answers

fork query

edited jan 22

created jan 22 jon.doe34463