SELECT tc.Nome, tc.email,(SELECT valor
FROM TabelaEmprestimo te
WHERE te.id_cliente = tc.id_cliente) as Valor
FROM TabelaClientes tc
WHERE EXISTS (
SELECT valor
FROM TabelaEmprestimo te
WHERE te.id_cliente = tc.id_cliente
AND EXISTS (
SELECT valor
FROM TabelaPagamentos tp
WHERE tp.id_emprestimo = te.id_emprestimo
AND tp.status = 'Pago'
)
);