How do I use multiple tables together?

[Anon]

I have a table that has user info and a table that refereces the user info. do i have to do multiple querys to display. For instance. if i do a search for someones phone # i would like to display all records that point to his userid. If someone can understand my confusion please help me.

[Anon]

Look here:

http://www.mysql.org/doc/M/u/Multiple_tables.html

[Anon]

SELECT usertable.name, phonetable.phonenumber FROM phonetable INNER JOIN ON phonetable.userid = usertable.id