diff options
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 2db02755..4c51ac70 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4173,7 +4173,7 @@ 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 LEFT JOIN accounts2 ON a.account=cash_account WHERE account_type='Fcm'; +AND trade_date = p_date) a LEFT JOIN accounts2 ON a.account=cash_account WHERE account_type='Fcm' and cp_code='BAMSNY'; END; |