1/24/22 - join posts and users info

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results