title: How do I convert this INNER JOIN query from SQL Server to MySQL?
body: <p>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. </p>
  
  <p>Can anyone help me work out how the following should be converted. </p>
  
  <pre><code>SELECT 
  &lt;columns&gt; 
  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 
  </code></pre>
  
  <p>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. </p>