Ayuda con una consulta desde el Query

[flaviovich]

Aver prueba asi:

Código SQL:

SELECT TOP 2 CER."Relational Exch_ Rate Amount"
FROM Monolitic.dbo."Currency Exchange Rate" CER
WHERE CER."Currency Code" IN ('USD','JPY')
AND CER."Starting Date" = (
    SELECT MAX("Currency Exchange Rate"."Starting Date") 
    FROM Basededatos.dbo."Currency Exchange Rate")
)