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