0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT TOP 100
  U1.DisplayName AS SFFUserName,
  U1.Id AS SFFUserId,
  U1.Reputation AS SFFReputation,
  U2.DisplayName AS ArqadeUserName,
  U2.Id AS ArqadeUserId,
  U2.Reputation AS ArqadeReputation
FROM [StackExchange.scifi].dbo.Users U1, [StackExchange.gaming].dbo.Users U2
WHERE
  U1.AccountId = U2.AccountId
ORDER BY
  CASE
    WHEN U1.Reputation > U2.Reputation THEN U2.Reputation
    ELSE U1.Reputation
  END DESC, U1.AccountId;

fork query

edited nov 28 anonymous

created oct 13 19 peterh (2)