select b.Id, c.Text, p.OwnerUserId from Badges b INNER JOIN

0

Please login or register to vote for this query.

(click on this box to dismiss)

Islam

Q&A for Muslims, experts in Islam, and those interested in learning more about Islam

select b.Id, c.Text, p.OwnerUserId
from Badges b INNER JOIN 
(SELECT Text, Id from Comments
where Id < 100000) c
on b.Id = c.Id INNER JOIN 
(SELECT OwnerUserId, Id from Posts
where Id < 100000) p 
on b.Id = p.OwnerUserId 
where b.Id < 100000

Enter Parameters

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