SELECT D.CLIENTIP, COUNT(1) FROM ( SELECT A.CLIENSEC, A.CLIENTIP AS CLIENTIP FROM SEFMPECO B, SEFMPERS A, SEFMPOLI C WHERE B.CLIENSEC = A.CLIENSEC AND B.CIAASCOD = C.CIAASCOD AND B.RAMOPCOD = C.RAMOPCOD AND B.POLIZANN = C.POLIZANN AND B.POLIZSEC = C.POLIZSEC AND B.CERTIPOL = C.CERTIPOL AND B.CERTIANN = C.CERTIANN AND B.CERTISEC = C.CERTISEC AND B.SUPLENUM = C.SUPLENUM AND C.SITUCPOL = ' ' AND A.FBAJAANN = 0 AND A.FBAJAMES = 0 AND A.FBAJADIA = 0 GROUP BY A.CLIENSEC, A.CLIENTIP ) D GROUP BY D.CLIENTIP
tipo_de_clientes_y_polizas:sefmpeco_sefmpers_sefmpoli
tipo_de_clientes_y_polizas/sefmpeco_sefmpers_sefmpoli.txt · Last modified: 2023/11/14 12:22 by 127.0.0.1