Validate parameter to disregard left Join

Question

I’m setting up a select, but depending on the value of a come parameter (store = 00000 - all stores), I’d like to skip the "AND p.store = e.store " section on the left Join so that it disregards the value and lists all stores.

I tried a few ways and I couldn’t :(

SELECT Isnull(d.idprocessoassinaturadigital, p.idprocessoassinaturadigital) AS 
   CodSequencia, 
   p.proposta                                                           AS 
   CodigoProposta, 
   p.empresa, 
   p.produto, 
   Isnull(d.idprocessoassinaturadigital, p.idprocessoassinaturadigital) AS 
   IdProcessoAssinaturaDigital, 
   p.statusassinatura 

   FROM   propostascredito p 
   LEFT JOIN proposta_ass_digital_multipla d 
          ON p.empresa = d.empresa 
             AND p.proposta = d.proposta 
   LEFT JOIN aprovacaoautomatica e 
          ON p.empresa = e.empresa 
             AND p.produto = e.produto 
             AND p.lojista = e.lojista 
             AND p.loja = e.loja 
    WHERE  p.empresa = '01'

Answer 1

Hello! You can take a look at the use of CASE with LEFT JOIN, as link below: Using Case When with Leftjoin

I hope it helps you.

Abs!