/*SELECT U.DisplayName, B.Name FROM Users AS U JOIN Badge...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

/*SELECT U.DisplayName, B.Name
FROM Users AS U JOIN Badges as B ON B.UserId = U.Id
WHERE U.Reputation > 1000;*/

/*SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName,
   B.Name
FROM Badges AS B
WHERE EXISTS DisplayName
ORDER BY B.Date*/

SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000)
FROM Badges AS B
WHERE B.UserId IN (SELECT U.Id
                   FROM Users U
                   WHERE U.reputation > 1000)

/*SELECT
(SELECT U.DisplayName
 FROM Users AS U
 WHERE U.Id = B.UserId AND U.Reputation > 1000)
 FROM Badges as B
 WHERE*/

  
/*SELECT U.DisplayName, U.test
FROM USers U
WHERE U.Reputation > 1000 AND U.test = (SELECT B.NAME
                                      FROM Badges AS B
                                      WHERE B.UserId = U.Id);*/
/*SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName
FROM Badges AS B
WHERE EXISTS DisplayName
ORDER BY B.Date*/

Enter Parameters

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