title: SQLite Inner Join not working converting from Access
body: <p>Could use some help converting this Access query to SQLite....</p>
  
  <pre><code>SELECT [Objects].[Object_ID], [Equation_Types].[Equation_Type], [Objects].[Dynamic], [Objects].[Visible], [Object_Types].[Object_Type], [DisplayFormats].[DisplayFormat]
  FROM (((((Objects INNER JOIN Object_Transactions ON [Objects].[Object_ID]=[Object_Transactions].[Object_ID]) INNER JOIN Strings ON [Objects].[String_ID]=[Strings].[String_ID]) INNER JOIN Object_Types ON [Objects].[Object_Type_ID]=[Object_Types].[Object_Type_ID]) INNER JOIN DisplayFormats ON [Objects].[DisplayFormat_ID]=[DisplayFormats].[DisplayFormat_ID]) INNER JOIN (Service_Types INNER JOIN ((Header INNER JOIN Services ON [Header].[Header_ID]=[Services].[Header_ID]) INNER JOIN Transactions ON [Services].[Service_ID]=[Transactions].[Service_ID]) ON [Service_Types].[Service_Type_ID]=[Services].[Service_Type_ID]) ON [Object_Transactions].[Transaction_ID]=[Transactions].[Transaction_ID]) INNER JOIN Equation_Types ON [Object_Transactions].[Equation_Type_ID]=[Equation_Types].[Equation_Type_ID]
  WHERE ((([Objects].[Dynamic])=True) And (([Objects].[Visible])=True) And (([Object_Types].[Object_Type])="DATA"));True) And (([Object_Types].[Object_Type])="DATA"));
  </code></pre>
  
  <p>Sorry for the formatting.</p>
  
  <p>The inner most joins are not recognizing the columns. </p>
  
  <pre><code>INNER JOIN Transactions ON [Services].[Service_ID]=[Transactions].[Service_ID]) ON [Service_Types].[Service_Type_ID]=[Services].[Service_Type_ID]) ON [Object_Transactions].[Transaction_ID]=[Transactions].[Transaction_ID]) 
  </code></pre>