Fabio,
Thank you for your reply. Stars have already been issued to Sergey, but your proposed solution seems to make a lot of sense too. (Help star is comming your way)
If you checked out Sergey's solution, would you care to comment on performance advantages that one solution has over the other?
To me it seems like Sergey's solution would execute faster than your, but maybe behind the scenes the two solutions are equivalent.
Einar
>Single field lookup:
>
>SELECT i.ItemId,
> ISNULL((SELECT UserName FROM User WHERE UserId = i.CreatorId),'Unknown') AS [Creator Name],
> ISNULL((SELECT UserName FROM User WHERE UserId = i.AssigneeId),'Unknown') AS [Assignee Name]
> FROM Item i
>
Semper ubi sub ubi.