SELECT DISTINCT PWEB.ACCT,ACCT.AABRV,PSPEC.PSPECNO,PDEM.PID1,PSPEC.PSCDTA,PDEM.PFNAME,PDEM.PLNAME,PDEM.PDOB,PSPEC.PSCDTA FROM PSPEC JOIN PORD ON ( PORD.PORD = PSPEC.PORD AND PORD.POEFDT = PSPEC.POEFDT ) JOIN PDEM ON ( PDEM.PUID = PSPEC.PUID AND PDEM.PEFDT = PSPEC.PEFDT ) JOIN PWEB ON ( PWEB.PSPECNO = PSPEC.PSPECNO ) JOIN ACCT ON ( ACCT.ACCT = PWEB.ACCT AND AACT=1 ) WHERE PSPEC.PSACT = 1 AND PWEB.ACCT IN ('997','998','999') AND ( UPPER(PDEM.PLNAME) LIKE 'TEST%' OR PDEM.PLNAME IS NULL ) AND ( ( PSPEC.PSCDTA >= '20190901' AND PSPEC.PSCDTA <= '20191113' ) OR PSPEC.PSCDTA ='' OR PSPEC.PSCDTA IS NULL )