diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index c27ba00d..581119ea 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -355,8 +355,8 @@ CREATE OR REPLACE FUNCTION et_cusip_details(p_cusips VARIADIC varchar(10)[]) d.subordination, d.thickness FROM cusip_universe a LEFT JOIN latest_clo_universe b ON a.dealname = b.dealname - JOIN (SELECT unnest($1) AS cusip, generate_subscripts(p_cusips, 1) AS id) c - ON a.cusip = c.cusip LEFT JOIN et_model_numbers d ON d.cusip = c.cusip ORDER BY c.id; + RIGHT JOIN (SELECT unnest($1) AS cusip, generate_subscripts(p_cusips, 1) AS id) c + ON c.cusip = a.cusip LEFT JOIN et_model_numbers d ON d.cusip = c.cusip ORDER BY c.id; END; $$ LANGUAGE plpgsql; |