>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,

You're right, of course! The Item half of the JOIN statements should have referred to the Creator and Assignee fields.

Regards,