0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

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

fork query

edited jan 26

created jan 24 jon.doe34463