Consulta Propostas CrefazMais

select b.nome, a.* from externo.ConsultaServico a with(nolock)
join Externo.IntegracaoServico b with(nolock)
on a.IntegracaoServicoId = b.Id
where PropostaServicoId = 14344 order by DataHora desc ------------- ID da proposta