Left Joining 2 tables 2 times!
Posted: Sun Jul 06, 2008 8:43 pm
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 ?
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 ?