join 3 tables with select

[kyriakos70]

Hello,
I have 3 tables (sql server 2005 express), 1 (eponimya) master 1 detail-master ([Month]) of 3 and 1 detail (KATASTASI).
I want to inner join all 3 with a select, eg:
SELECT * from eponimya inner join [Month] on eponimya.id = [Month].id_2 (inner join KATASTASI on KATASTASI.id_2=[Month].id

How can I syntax this?

Thank you
Kyriakos

 

[gmmastros]

It looks like the query you already wrote should work, except you have an open parenthesis without a close parenthesis. You can remove that parenthesis altogether.

SELECT * 
from   eponimya 
       inner join [Month] 
         on eponimya.id = [Month].id_2 
       inner join KATASTASI 
         on KATASTASI.id_2=[Month].id

Try that. If you get an error, post back with the error message.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom