title: SQL multiple join statement
body: <p>When I had only one inner join in my SQL statement, it worked perfectly. I tried joining a second table, and now I am getting an error that says there is a syntax error (missing operator). What is wrong here?</p>
  
  <pre><code>adsFormView.SelectCommand = "SELECT * FROM [tableCourse] INNER JOIN [tableGrade] ON [tableCourse].[grading] = [tableGrade].[id] INNER JOIN [tableCourseType] ON [tableCourse].[course_type] = [tableCourseType].[id] WHERE [prefix]='" &amp; myPrefix &amp; "' AND [course_number]='" &amp; myCourseNum &amp; "'"
  </code></pre>