diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 8de66e28..4a78f354 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1071,6 +1071,7 @@ AS SELECT bonds.dealid, accounts.fund, counterparties.code AS cp_code, counterparties.name AS counterparty + counterparties.dtc_number FROM bonds LEFT JOIN bond_allocation ON bonds.id = bond_allocation.tradeid LEFT JOIN accounts USING (code) |