[SOLVED] I want to join user table with log table twice

Issue

This Content is from Stack Overflow. Question asked by manjil Sthapit

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



Solution

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


This Question was asked in StackOverflow by manjil Sthapit and Answered by Sergey It is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?