NEED FROM CLAUSE WITH NESTED INNER JOIN

[TNN]

Can anyone write me a FROM clause with a nested INNER JOIN that joins 3 tables with common fields??
I have looked at the syntax but have been unable to write it properly to make it work.

Thank You
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[braindead2]

Not sure if this is what you mean but this is what the SQL looks like with 3 tables joined and a where condition thrown in.

Select table1.field,table2.field,table3.field
From table1 Inner join [table2 innerjoin table3 on table2.indexfield = table3.indexfield] on table1.indexfield = table3.indexfield
where table1.field = "your criteria"