sql: access database inner joins

[tuneman202002]

I was trying to create a sql statement in access to inner join 3 tables, here is my code:

SELECT; resorts.*, location.State, Rating.Opinion
FROM (resorts INNER JOIN location ON resorts.LID=location.LID")
INNER JOIN Rating ON resorts.RATID=Rating.RATID

When I run this though, I get "The select statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect."

Does anyone have some advise on this problem?

Thank you

[LifeinAsia]

Get rid of whatever that is after location.LID (2 single quotes? double quotes?)

And welcome to WebmasterWorld!