Is it possible to inner join three tables?

I have these two in the Dreamweaver Advanced Dialogue Box:


SELECT *
FROM producers_pro INNER JOIN allcrew ON idper_pro=id_per

and I want to also INNER JOIN kindofproducer_kin ON kindofproducer_pro=nameofproducer_kin

Is this possible?

Thanks!

certainly can. but u must make sure that they all have the common fields. I suppose that namefproducer_kin is in the producers_pro table.
If it is then it shud work.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
certainly can. but u must make sure that they all have the common fields. I suppose that namefproducer_kin is in the producers_pro table.
If it is then it shud work.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks!

But what's the syntax for it...like what do I write after the first INNER JOIN?

emily

SELECT *
FROM producers_pro INNER JOIN allcrew ON idper_pro=id_per INNER JOIN kindofproducer_kin ON kindofproducer_pro=nameofproducer_kin