select from three tables and WHERE statement

[doc1355]

I have a feeling that this is an easy question. However I'm a newbee and don't have any idea how to do this.
I have three tables that stores my users information. Each user has a unique ID that is same in all three tables and is the way that connects the data for the user.
Table1 has userid and useremail
Table2 has userid and status
Table3 has userid and name, email, phone number and .....

user status can be Active, Pending, Expired or Canceled.

I need to have a page that shows only Active users with their details on each row.

I know I need to use SELECT and WHERE, but I can do that only for table2. When I try to add other tables to it everything gets missed up.

Thanks

[stepterr]

You'll want to use JOIN between the tables. Something like this should work for you.

[PHP] Select
TABLE1.*, TABLE2.*, TABLE3.*
From
TABLE1
Inner Join TABLE2 On
TABLE1.ID = TABLE2.ID
Inner Join TABLE3 On
TABLE2.ID = TABLE3.ID [/PHP]