Yes. See my other reply to your post.

>Is it legal to have a second INNER JOIN if I need to pull information from a third table?