Search found 1 match

by Rdam
Sun Jul 06, 2008 8:43 pm
Forum: Databases
Topic: Left Joining 2 tables 2 times!
Replies: 1
Views: 532

Left Joining 2 tables 2 times!

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 ?