Page 1 of 1

Left Joining 2 tables 2 times!

Posted: Sun Jul 06, 2008 8:43 pm
by Rdam
Left Joining 2 tables 2 times!
Hi there,
I have two tables, the 1st tables name is USER
2nd table name is movement

this is the record example

user
Userid Username
1 Federer
2 NADAL
3 Rod****

Movement
Owner User
3 1
3 2


Expected Result
Owner User
Rod**** Federer
Rod**** Nadal


How can i do that ?

Re: Left Joining 2 tables 2 times!

Posted: Mon Jul 07, 2008 4:10 am
by VladSun
[sql]SELECT     User.Username, UserAlias.UsernameFROM    MovementINNER JOIN    User ON User.id = Movement.Owner INNER JOIN    User AS UserAlias ON UserAlias.id = Movement.User[/sql]