diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index aabf8059..c7221ac0 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1779,7 +1779,7 @@ CREATE OR REPLACE VIEW swaption_trades AS SELECT swaptions.id, dealid, termination_date as trade_date, - notional, + termination_amount as notional, security_desc, security_id, CASE WHEN termination_cp=cp_code THEN @@ -1795,7 +1795,7 @@ SELECT swaptions.id, strike, NOT buysell AS buysell, -termination_fee AS fee -FROM terminations RIGHT JOIN swaptions USING (dealid) +FROM terminations LEFT JOIN swaptions USING (dealid) LEFT JOIN counterparties ON termination_cp = code UNION ALL ( SELECT id, |