Bits of .NET

SELECT *
FROM Users u
WHERE EXISTS (
  SELECT 1 FROM Orders o WHERE o.UserId = u.Id
);

Why this matters
EXISTS short-circuits; IN often materializes full sets.