INNER JOINs in SQL

[Guest_imported]

Hi,

I am trying to execute an SQL code recently exported from MSAccess. Basically MySQL isn't accepting INNER JOINs - How do you write an SQL code in MySQL so that it can read INNER JOINs?

I would appreciate any quick response to this frustrating query.

Thanks,

Chris

 

[eddiebt]

query = "SELECT * FROM cal_events AS E INNER JOIN cal_dates AS D" _
& " ON (E.event_id = D.event_id) " _
& " WHERE event_date BETWEEN " _
& ' 2001-03-01 ' _
& " AND " ' 2001-03-31 '

This is an example that works. You may need to check your version of MySQL. Previous to version 3.23.16, the INNER JOIN didn't take a join condition! The latest version is 3.23.35.