Hi !
I need help to for below described problem. I have three tables.
Table 1 == Three fields == id, uid, mid
Table 1 data records
=========================================
id uid mid
1 0 1
2 1 0
3 2 0
4 0 1
Table 2 == Two fields == uid, uname
Table 2 data records
=========================================
uid uname
1 "username xyz"
Table 3 == Two fields == mid, mname
Table 3 data records
=========================================
mid mname
1 "mgrname xyz"
I want to fatch all the records of Table1, with the uname/mname from the Table 2 / Table 3.
Can anybody help please..
Thanx !