title: Incorrect Syntax near ';' (Microsoft SQL Server Error 102)
body: <p>First off, I have been searching all over for an answer to this, and I am also new to SQL coding, so please bear with me.</p>
  <p>I am trying to discover the current health status of client machines in SCCM 2012r2 with a custom report, please see code below:</p>
  <pre><code>SELECT     v_r_system.name0                                       AS 'Computer Name', 
             v_gs_antimalwarehealthstatus.lastquickscanage          AS 'Days since last quick scan',
             v_gs_antimalwarehealthstatus.lastfullscanage           AS 'Days Since Last Full Scan',
             v_gs_antimalwareinfectionstatus.computerstatus         AS 'Current Status', 
             v_gs_antimalwareinfectionstatus.lastcleaneddectiontime AS 'Last Cleaned' 
  FROM       v_gs_antimalwarehealthstatus 
  INNER JOIN v_gs_antimalwarehealthstatus 
  INNER JOIN v_r_system 
  ON         v_gs_antimalwarehealthstatus.resourceid = v_r_system.resourceid 
  INNER JOIN v_gs_antimalwareinfectionstatus;
  </code></pre>
  <p>When I try it out in Report Builder 3.0 I keep getting following error:</p>
  <p><a href="https://i.stack.imgur.com/ldjfV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ldjfV.png" alt="Error 102" /></a></p>
  <p>I can't seem to find the problem, it's driving me crazy...</p>
  <p>Anyway, anything you can do to point me in the right direction would be great.</p>
  <p>Cheers</p>