SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU1) (KB4527376) - 15.0.4003.23 (X64) 
	Dec  6 2019 14:53:33 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table USERS (
  ID_USER  numeric primary key
 ,NAME     varchar
)
create table TASKS (
  ID_TASK     numeric primary key
 ,NAME_TASK   varchar
 ,ID_HANDLER  numeric foreign key references USERS (ID_USER)
 ,ID_CREATOR  numeric foreign key references USERS (ID_USER)
)
insert into USERS values (1, 'G')
1 rows affected

insert into USERS values (2, 'M')
1 rows affected

insert into TASKS values (1, 'X', 2, 1)
1 rows affected

select T.NAME_TASK
      ,(select U1.NAME from USERS U1 where U1.ID_USER = T.ID_HANDLER) as HANDLER
      ,(select U2.NAME from USERS U2 where U2.ID_USER = T.ID_CREATOR) as CREATOR
  from TASKS T


NAME_TASK
HANDLER
CREATOR


X
M
G