How do I convert this INNER JOIN query from SQL Server to MySQL?

Question

I'm currently migrating a customers application from ColdFusion on Windows with SQL Server to ColdFusion on Linux with MySQL and I'm running into some issues recreating their views with regards to joins.

Can anyone help me work out how the following should be converted.

SELECT 
<columns> 
FROM assetType 
INNER JOIN assets
INNER JOIN AssetToContent ON assets.asset_id = AssetToContent.asset_id 
ON assetType.asset_typeID = assets.asset_typeID 
RIGHT OUTER JOIN ContentType 
INNER JOIN Content ON ContentType.ContentTypeID = Content.ContentTypeID 
ON AssetToContent.ContentID = Content.ContentID 
LEFT OUTER JOIN Page_Content ON Content.ContentID = Page_Content.ContentID 
RIGHT OUTER JOIN Page ON Page_Content.PID = Page.PID 

The INNER JOIN's without an ON clause are what are tripping me up and I can't find any good SQL Server docs on the ordering of nested joins.

Answer 1

This should work. I don't know what voodoo syntax SQL Server uses, but your ON clauses were all over the place:

SELECT 
<columns> 
FROM assetType 
INNER JOIN assets ON assetType.asset_typeID = assets.asset_typeID 
INNER JOIN AssetToContent ON assets.asset_id = AssetToContent.asset_id 
INNER JOIN Content ON AssetToContent.ContentID = Content.ContentID 
RIGHT OUTER JOIN ContentType ON ContentType.ContentTypeID = Content.ContentTypeID 
LEFT OUTER JOIN Page_Content ON Content.ContentID = Page_Content.ContentID 
RIGHT OUTER JOIN Page ON Page_Content.PID = Page.PID