SQL Server 2019

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

create table userTb (id int, name varchar(50));
create table orderTb (id_order int, qty int, id_user int, updatedby int);

insert into userTb values (1, 'paul'), (2, 'mark');
insert into orderTb values (1, 5, 2, 1);
3 rows affected

Select * from orderTb;
Select * from userTb;


id_order
qty
id_user
updatedby


1
5
2
1




id
name


1
paul

2
mark


SELECT o.id_order, o.qty, u1.name as name1, u2.name as name2 
FROM orderTb o
INNER JOIN userTb u1 ON u1.id=o.id_user
INNER JOIN userTb u2 ON u2.id=o.updatedby;


id_order
qty
name1
name2


1
5
mark
paul