-- CADASTRO DOS CLIENTES + PRODUTOS
SELECT * --from protheus.zam010
       --/*
       zc0.ZC0_FILIAL AS FILIAL,
       zc0.ZC0_CODCLI AS COD_CLIENTE,
       zc0.ZC0_NOMCLI AS NOME_CLIENTE
       ZAM_FILIAL AS FILIAL,
       ZAM_CONTRT AS NUMERO_CONTRATO,
       ZAM_NOMCLI AS NOME_CLIENTE,
       ZAM_CODPRO as COD_PRODUTO,
       B1.B1_desc as DESCRICAO,
       ZAM_MUNICI as MUNICIPIO,
       REGEXP_REPLACE(ZAM_DTNAS,'([0-9]{4})([0-9]{2})([0-9]{2})','\3/\2/\1') DATA_NASCIMENTO,
       REGEXP_REPLACE(ZAM_EMISSA,'([0-9]{4})([0-9]{2})([0-9]{2})','\3/\2/\1') DATA_ADESAO,
       REGEXP_REPLACE(ZAM_DTSTAT,'([0-9]{4})([0-9]{2})([0-9]{2})','\3/\2/\1') DATA_DISTRATO,
       zam_obito NUM_OBITO,
       REGEXP_REPLACE(zam_dtobt,'([0-9]{4})([0-9]{2})([0-9]{2})','\3/\2/\1') DATA_OBITO,
       ZAM_END as ENDERECO,
       ZAM_COMP as COMPLEMENTO,
       ZAM_REFEND as REFERENCIA,
       ZAM_BAIRRO as BAIRRO,
       ZAM_EST as ESTADO,
       ZAM_TELOUT as TELEFONE
     --*/
     --/*
FROM protheus.zam010 zam
INNER JOIN protheus.sb1010 b1
ON  b1.b1_cod = zam.zam_codpro
AND b1.d_e_l_e_t_ = ' '
INNER JOIN protheus.sb1010 b1
ON  b1.b1_cod = zam.zam_codpro
INNER JOIN protheus.ZC0030 zc0
ON  zc0.ZC0_CODCLI = zam.zam_codcli
and zc0.ZC0_FILIAL = zam.zam_FILIAL
WHERE zam_status = '1'
 --and zam.ZAM_OBITO <>' '
AND zam.D_E_L_E_T_ = ' '
AND zam.ZAM_DTSTAT = ' '
--AND b1.B1_desc like 'SEMPRE%' or b1.B1_desc like 'SAFRA%'
--AND zam.ZAM_MUNICI like 'SAO JOSE%' --or zam.ZAM_MUNICI LIKE 'BREJINHO%' or zam.ZAM_MUNICI LIKE 'NISIA%' or zam.ZAM_MUNICI LIKE 'MONTE%' or  zam.ZAM_MUNICI LIKE 'SAO JOSE%'
ORDER BY zam.ZAM_MUNICI
        --*/