Jim,
Logically I don't think your suggestion will work. I didn't test your suggestion but I think Sergey's solution is the only proposed solution that will work.

Einar
>
>Not tested, but I think this should work.
>

>SELECT Item.ItemID, ;
>       Creator.UserName , ;
>       Assignee.UserName ;
>  FROM Item JOIN User Creator ;
>   ON Item.UserID = Creator.UserID ;
>  JOIN User Assignee ;
>   ON Item.UserID = Assignee.UserID
>

>
>Regards,