Home

Rule description

• SQL EXISTS subqueries should not be used

Non-compliant Code Example

SELECT 
    NAME,
    ADDRESS,
    CREDIT_LIMIT       
FROM
    CUSTOMERS
WHERE EXISTS (SELECT NAME FROM VENDOR WHERE VENDOR.NAME = CUSTOMERS.NAME) --Non compliant code (SQL EXISTS sub-queries is used)

Compliant Code Example

SELECT 
    NAME,
    ADDRESS,
    CREDIT_LIMIT       
FROM
    CUSTOMERS
INNER JOIN VENDOR 
	ON VENDOR.NAME IS NOT NULL AND VENDOR.NAME = CUSTOMERS.NAME;  --Compliant code (SQL EXISTS sub-queries is not used)