A good rule suggestion:
-
description of the Rule answering to the question “why?” : what’s the impact to keep this code as it is ?
Avoid using of implicit join or Mixup of implicit and explicit join should be avoid to increase the readability. -
snippet of Noncompliant Code
SELECT a.test1, b.test1
FROM tableA AS a, tableB AS b
INNER JOIN tableC AS c
ON b.test1 = c.test1
WHERE a.test1 = b.test1 -
snippet of Compilant Code (fixing the above noncompliant code)
SELECT a.test1, b.test1
FROM tableA AS a
INNER JOIN
,tableB AS b
ON a.test1 = b.test1
INNER JOIN tableC AS c
ON b.test1 = c.test1 -
external references and/or language specifications
-
type : Code Smell
-
tags