SELECT * FROM MRCBaseline..DMSBLCustomerLocation cl
 INNER JOIN ( SELECT * FROM BAccount WHERE CompanyID =3 AND (UsrActive = 0 OR UsrActive IS NULL)
) AS usrActive
ON usrActive.CompanyID = cl.CompanyID
AND cl.CustomerID = usrActive.BAccountID
AND cl.CustomerCD = usrActive.AcctCD
 LEFT JOIN DMSViewGetCustomerLocationByDistributor cld
 ON cld.CompanyID = cl.CompanyID AND cld.CustomerID = cl.CustomerID
 AND cld.CustomerCD = cl.CustomerCD