I want to join user table with log table twice-CodePudding

Home > Mobile > I want to join user table with log table twice

I want to join user table with log table twice

Time：09-19

user table:

id = 1
name = David,
id= 2
name = Jhon

log table:

user_id = 1
guest_id = 2

wanted output

user_name = David
guest_name = Jhon

CodePudding user response：

SELECT T.NAME,T2.NAME
FROM LOG_TABLE L
JOIN USER_TABLE T ON L.USER_ID=T.ID
JOIN USER_TABLE T2 ON L.guest_id =T2.ID

You can use something like this