[Страдалецъ]

Вот так попробуйте:

Код:

Select Call.number, Call.Description, User.Примечания as Клиент, Owner.Примечания as Владелец
 from Call
 inner join Пользователи as User on Call.ClientID = User.IMObjID
 inner join Пользователи as Owner on Call.ExecutorID = Owner.IMObjID