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 19952cbd..4c4c9fae 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -442,7 +442,7 @@ CREATE OR REPLACE FUNCTION et_aggdealinfo_historical (p_dealname varchar(10), p_ bool_or(c.secondlien)) AS secondlien, bool_or(a.iscdo) AS iscdo, bool_or(a.defaultedflag) AS defaultedflag, a.et_loanxid, a.et_cusip FROM et_historicaldealinfo(p_dealname, p_date) a - LEFT JOIN historical_markit_prices2(p_date) b ON a.loanxid=b.loanxid + LEFT JOIN historical_markit_prices2(p_date) b ON upper(a.loanxid)=b.loanxid LEFT JOIN historical_bloomberg_corp(p_date) c ON a.cusip=c.cusip WHERE a.dealname = p_dealname GROUP BY a.issuername, a.maturity, a.loanxid, a.fixedorfloat, |