How to query a many-to-many relationship? w/ Consecutive inner joins?

[pufftissue]

I have a many-to-many relationship linked via a bridging or linking table. I understand that this is proper form. Now how do I query it and bring it back together? Do I do it with consecutive inner joins b/c I can't get the syntax to work. Or does this require subqueries?

Tests <--- Tests-Reasons -----> Reasons

1 1 5 5

What I'd like to to do is bring Table Tests and Table Reason together.

Thanks!

[laserlight]

Yes, using two joins is correct (unless you actually only need one join). What did you try and how does it not work?