Need Help in Mysql and ASP

Hi
I am heaving problem to exerting data from MYSQL using ASP. I want to extract data from three tables, one field from each table, which does not work. This is the sql statement

SELECT table1.field1, table2.field2, table3.field3
FROM table1 INNER JOIN (table2 INNER JOIN table3 ON table2.field4 = table3.field4) ON table1.field5 = table3.field5

Please advice me
Thank you

im a newbie but I didnt know ASP could interface with MySQL?

Whats the error your are getting all1234? Is it a SQL error?

There are no major problems when it comes to using MySQL w/ ASP as there is an ODBC driver for it. In fact, there aren't a great deal of DB's that you can't use with ASP. Personally, I've used postGresSQL, MySQL, SQLServer, Oracle (on Linux & Windows) and Access all on commercial projects... they're all pretty much the same - i.e. SQL is SQL is SQL. (apart from a few minor syntactical differences.)

Try your query from the MySQL command-line interface. If it works, then there is a problem w/ your ASP. Simple.

stumpy.

Well I solved this problem. That was SQL syntax error. Because lower MYSQL version does not support INNER JOIN but newer version does. So instead of INNER JOIN I used WHERE AND in SQL statement. Which solved every thing

Thanks to all for trying