Complex query - Two inner joins?

[raydex]

Hi

I am fairly new to PHP/MySQL but have used Dreamweaver to develop a site which allows people to apply for free assistance. There are 3 tables - users, apps and advisers. The app table has reference to the ids in the other two tables eg iduser_user, idadviser_adviser.

What I want to do now is use data from all 3 tables. I want to display the application details, user details and the allocated adviser. I am stuck as to how to get this into one record set so any help very gratefully received.

Hope I have explained it well
Thanx -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[nashua]

Code:

select users.foo
, apps.bar
, advisers.qux
from users
inner
join apps
on apps.iduser_user = users.id
inner
join advisers
on advisers.id = apps.idadviser_adviser

Hope this helps -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --