Connect to multiple tables

[anuj_sharma]

Hey Guys,
I want to know how can you connect to multiple tables at a time.
I need one table to validate the username and pasword.
I need another table to show his details.
Please Give Some suggestions(I am using php and MySQL)

[dickersonka]

not sure what your table structure is like but something like this should work

select * from userlogins ul
inner join userdetails ud
on ul.USER_ID = ud.USER_ID

[Shanti C]

yes , you can write joins to get your desired details...

select l.user_name,l.password,u.fname,u.lname,u.address from login_table as l,user_table as u where l.user_id=u.user_id;