inner join problems?

[admin]

Hi,

I wanted to select data from more than two tables, codes like

"SELECT table1.name1, table2.name3, table3.name2, table3.name3 FROM table3 inner JOIN table2 inner JOIN table1 ON table1.name2=table2.name2 ON table2.name1=table1.name2 WHERE (((table1.name1)>3000) AND ((table2.name3)="test")); "

but I always got error (

ERROR 1064: You have an error in your SQL syntax near 'inner JOIN table1 ON tabl
e1.name2=table2.name2 ON table2.name1=table1.name2 WHER' at line 1

Have someone any insight?

thanks,