Fórum SQL ME AJUDEM #617227

select
    ass.nm_assinante,
    end.ds_endereco,
    end.complemento,
    end.bairro,
    end.CEP,
    mun.ds_municipio,
    tel.ddd,
    tel.n_fone
from
    assinante ass
left join
    ass_end aend on
    aend.cd_assinante = ass.cd_assinante
left join
    endereco end on
    end.cd_endereco = aend.cd_endereco
left join
    end_munic emun on
    emun.cd_endereco = end.cd_endereco
left join
    municipio mun on
    mun.cd_municipio = emun.cd_municipio
left join
    end_fone efon on
    efon.cd_endereco = end.cd_endereco
left join
    telefone tel on
    tel.cd_fone = efon.cd_fone