title: Use of parenthesis in Sql Join statement
body: <p>I would like to know what is the difference between </p>
  
  <pre><code>INNER JOIN TB_PACKAGE AS B
      ON (A.CdPackage = B.CdPackage)
  </code></pre>
  
  <p>and</p>
  
  <pre><code>INNER JOIN TB_PACKAGE AS B
      ON A.CdPackage = B.CdPackage
  </code></pre>
  
  <p>When I should use the parenthesis and when not, I need some sort of explanation.</p>
  
  <p>Here is the entire query, it is a stored procedure:</p>
  
  <pre><code>SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  ALTER PROCEDURE [DB].[SP_UP_NOTES]
    @COD_ROTE  NUMERIC(10)
   ,@COD_STATS   NUMERIC(10)
  AS
  
  BEGIN
  
    UPDATE C
    SET C.IdStatus = @COD_STATS
    FROM DB.TB_NOTES AS A
    INNER JOIN OPMDM.TB_PACKAGE AS B
      ON (A.CdPackage= B.CdPackage)
    INNER JOIN OPMDM.TB_NOTES AS C
      ON (A.CdNotes = c.CdNotes)
    WHERE B.STATS = @COD_ROTE;
  
  END
  </code></pre>