diff options
| -rw-r--r-- | sql/dawn.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index dc64b86f..d2905dd8 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -1075,8 +1075,9 @@ AS SELECT bonds.dealid, bond_allocation.notional AS faceamount, accounts.fund, counterparties.code AS cp_code, - counterparties.name AS counterparty - counterparties.dtc_number + counterparties.name AS counterparty, + counterparties.dtc_number, + bond_allocation.code as account FROM bonds LEFT JOIN bond_allocation ON bonds.id = bond_allocation.tradeid LEFT JOIN accounts USING (code) |