diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2ddd365f..364e7374 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -503,7 +503,7 @@ BEGIN RETURN QUERY select c.dealid, c.security_id, c.maturity, (CASE WHEN buysell = 't' THEN 1 ELSE -1 END) * c.notional as notional, c.swaption_type, c.strike, c.expiration_date, d.market_value, c.initial_margin_percentage, d.date as latest_model_date, d.delta, d.gamma, d.vega from swaptions c -inner join( +left join( select a.dealid, a.date, a.market_value, a.delta, a.gamma, a.vega from swaption_marks as a inner join ( select dealid, max(date) as latest_model_date |