INNER JOINs on MS Access database in ASP 1

[mattygriff]

I am using the following SQL query to try to retrieve data from one database table in date order based on a field in another table :

SELECT results.*, fixtures.fixdate FROM fixtures INNER JOIN results ON fixtures.fixID = results.fixID ORDER BY fixtures.fixdate

but I keep getting a syntax error message when I try to render the page. I generated the query from within MS Access so all the table and field names are correct.

Can anyone help ?

 

[Geee]

Get your partner (the more talented ASP programmer) to do the page for you? -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[iowtech]

Please post the exact error message, the line and surrounding code where the error is and your connection info.

 

[Geee]

Try...

SELECT results.*, fixtures.fixdate FROM results INNER JOIN results ON fixtures.fixID = results.fixID ORDER BY fixtures.fixdate ASC

G
-GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-