diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index ababbc39..2db02755 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4173,13 +4173,9 @@ AND trade_date = p_date AND fund=p_fund UNION SELECT cash_account AS account, sell_currency AS curr, sell_amount AS totbal, buy_currency AS homecurrency, spot_rate AS fxrate, sell_amount AS convtotbal, 'Sell' AS buysell, settle_date AS valuedate FROM spots WHERE buy_currency = 'USD' AND fund=p_fund -AND trade_date = p_date) a WHERE a.account in ('V0NSCLMSPT', '6MZ20K79'); +AND trade_date = p_date) a LEFT JOIN accounts2 ON a.account=cash_account WHERE account_type='Fcm'; -<<<<<<< HEAD END; $function$ -; -======= -END; ->>>>>>> a416656e (Will do rounding within the script) +;
\ No newline at end of file |