diff options
| -rw-r--r-- | sql/et_tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 1edf23b5..19952cbd 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -375,7 +375,7 @@ CREATE OR REPLACE FUNCTION et_aggdealinfo (p_dealname varchar(10)) bool_or(c.covlite))) AS covlite, (bool_or(a.secondlien) OR bool_or(c.secondlien)) AS secondlien, bool_or(a.iscdo) AS iscdo, bool_or(a.defaultedflag) AS defaultedflag FROM et_latestdealinfo(p_dealname) a - LEFT JOIN latest_markit_prices2 b ON a.loanxid = b.loanxid + LEFT JOIN latest_markit_prices2 b ON upper(a.loanxid) = b.loanxid LEFT JOIN bloomberg_corp c ON a.cusip=c.cusip WHERE a.dealname = p_dealname GROUP BY a.issuername, a.maturity, a.loanxid, a.fixedorfloat, a.frequency, a.cusip ORDER BY issuername; |