What's wrong with this query?

[jsoldi]

I'm new to Access. I'm trying to run this SQL query:

SELECT 
Title.InnerText AS SystemID, 
RamSerial.InnerText AS RamSerial, 
RamTitle.InnerText AS RamTitle, 
RamModuleSize.InnerText AS RamModuleSize,
RamPackage.InnerText AS RamPackage,
RamFeature.InnerText AS RamFeature,
RamSpecs.InnerText AS RamSpecs,
Rating.InnerText AS Rating,
Price.InnerText AS Price,
RamSerial.Url
FROM 
Title LEFT JOIN TitleInRam ON Title.InnerText = TitleInRam.InnerText 
LEFT JOIN RamSerial ON TitleInRam.Url = RamSerial.Url 
LEFT JOIN RamTitle ON TitleInRam.Url = RamTitle.Url 
LEFT JOIN RamModuleSize ON TitleInRam.Url = RamModuleSize.Url 
LEFT JOIN RamPackage ON TitleInRam.Url = RamPackage.Url
LEFT JOIN RamFeature ON TitleInRam.Url = RamFeature.Url
LEFT JOIN RamSpecs ON TitleInRam.Url = RamSpecs.Url
LEFT JOIN Rating ON TitleInRam.Url = Rating.Url
LEFT JOIN Price ON TitleInRam.Url = Price.Url

But I get the error: "Syntax error (missing operator) in query expression 'Title.InnerText = TitleInRam.InnerText...'". The actual error message shows my query from "Title.InnerText = TitleInRam.InnerText" to the end.

[RuralGuy]

Have you tried it without all of the .InnerText references?

[evander]

1. There is no semi-colon (unless you intentionally removed that).
2. Access SQL prefers nested joins, multi-table equijoins. Meaning, you have to specify which gets joined first to what, using lots of parentheses.
3. Maybe TitleinRam.url is joined to a lot of tables?

Try creating your query in a QBE. And join one table at a time, until you stumble on the join that makes your entire query fail.

Good luck.