title: Multiple Inner Joins Error
body: <p>I am attempting a select query pulling information from 5 different tables and I am getting errors in the from part. I have tried several variations of the code and nothing is working. Below is the code and error.</p>
  
  <pre><code>SELECT incident.incidentowner, 
         incident.qualitymember, 
         incident.purchasingmember, 
         incident.additionalmember, 
         incident.customername, 
         incident.customercontact,
         incident.incidentid, 
         incident.stockcode, 
         incident.incidentdate,
         incident.stocksupplier,
         incident.customeraccountno,
         incident.supplydate,
         incident.incidentsite,
         incident.depot, 
         incident.samplesent,
         incident.quantity, 
         incident.incidentvalue, 
         incident.branchtransfer,
         incident.hireorsale,
         incident.quarantined,
         incident.returnedtosupplier,
         incident.replacedbysupplier,
         incident.creditedbysupplier,
         incident.incidentdescription,
         containment.containment,
         containment.containmentdate,
         rootcause.rootcause,
         rootcause.rootcausedate,
         correctiveaction.correctiveaction,
         correctiveaction.correctiveactiondate,
         validation.validation,
         validation.director,
         validation.validationdate 
  FROM Incident 
  INNER JOIN containment ON 
        incident.incidentid = containment.incidentid
  INNER JOIN rootcause ON
        incident.incidentid = rootcause.incidentid
  INNER JOIN correctiveaction ON
        incident.incidentid = correctiveaction.incidentid
  INNER JOIN validation ON
        incident.incidentid = validation.incidentid
  WHERE Incident.IncidentID = @incidentid
  </code></pre>
  
  <p>this returns the following error</p>
  
  <pre><code> Additional information: Syntax error (missing operator) in query expression
  'incident.incidentid = containment.incidentid INNER JOIN rootcause ON
   incident.incidentid = rootcause.incidentid INNER JOIN correctiveaction ON 
   incident.incidentid = correctiveaction.incidentid INNER JOIN validation ON       
   incident.incidentid = validation.inci'.
  </code></pre>