Sql Help Needed !

[varsh]

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 !

[mikosiko]

it is extremely easy for anybody here to give you the code for that, but it is better if you learn it for yourself... so... read http://dev.mysql.com/doc/refman/5.0/en/join.html