diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 607d1b63..f66ddbdc 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3900,7 +3900,8 @@ AS SELECT a.*, c.name from(SELECT unnest(ARRAY[fx_swaps.dealid::text, fx_swaps.d unnest(ARRAY[fx_swaps.near_buy_amount, fx_swaps.far_buy_amount]) AS buy_amount, unnest(ARRAY[fx_swaps.near_sell_amount, fx_swaps.far_sell_amount]) AS sell_amount, unnest(ARRAY[fx_swaps.near_cpty_id, fx_swaps.far_cpty_id]) AS cpty_id, - unnest(ARRAY[fx_swaps.near_rate, fx_swaps.far_rate]) AS spot_rate + unnest(ARRAY[fx_swaps.near_rate, fx_swaps.far_rate]) AS spot_rate, + fx_swaps.id as id FROM fx_swaps UNION SELECT spots.dealid, @@ -3915,7 +3916,8 @@ UNION spots.buy_amount, spots.sell_amount, spots.cpty_id, - spots.spot_rate + spots.spot_rate, + spots.id as id FROM spots) a LEFT JOIN counterparties c ON cp_code=code ; |