diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/et_tables.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 842bd627..1edf23b5 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -285,8 +285,11 @@ CREATE VIEW latest_cusip_universe AS GRANT ALL ON latest_cusip_universe TO et_user; +-- CREATE VIEW dealcusipmapping AS +-- SELECT dealname, unnest("Deal Cusip List") AS Cusip from latest_clo_universe; + CREATE VIEW dealcusipmapping AS - SELECT dealname, unnest("Deal Cusip List") AS Cusip from latest_clo_universe; + SELECT dealname, cusip from latest_cusip_universe; GRANT ALL ON dealcusipmapping TO et_user; |