RFC4_1.sql

SELECT *
FROM INTERMEDIARIO i INNER JOIN SolicitudOperacion s ON s.FK_ID_INTERMEDIARIO = i.ID_INTERMERMEDIARIO JOIN Inversionista v
ON s.ID_INVERSIONISTA = v.ID_INVERSIONISTA
WHERE s.FK_ID_VALOR =
(SELECT ID_VALOR
FROM Valor WHERE FK_ID_TIPO_VALOR = (SELECT ID_TIPO_VALOR
FROM TipoValor
WHERE NOMBRE_VALOR = $P{tipoValor}))