select P.PES_NOME as NOME
     , P.PES_RAZSOC as RAZAOSOCIAL
     , P.PES_CNPJF  as CNPJCPF
     , P.PES_EMAIL  as EMAIL
     , P.PES_FONERE as TELEFONERESIDENCIAL
     , P.PES_FONECO as TELEFONECOMERCIAL
     , P.PES_FONECE as TELEFONECELULAR
     , P.PES_ENDERE as ENDERECO
     , P.PES_NUMERO as NUMERO
     , P.PES_BAIRRO as BAIRRO
     , P.PES_COMPLE as COMPLEMENTO
     , P.PES_CEP as CEP
     , C.CID_DESCRI as CIDADE
     , C.UF_CODIGO as ESTADO
     , P.PES_AUTFAT
From
PESSOA P
join CIDADE C
on C.CID_CODIGO=P.CID_CODIGO
where P.PES_AUTFAT = 1