SQL Query
From: gavs <gavspp_at_yahoo.com>
Date: 16 Oct 2002 09:00:24 -0700
Message-ID: <54dc4b2a.0210160800.64c6c327_at_posting.google.com>
Date: 16 Oct 2002 09:00:24 -0700
Message-ID: <54dc4b2a.0210160800.64c6c327_at_posting.google.com>
Hello:
I need help with formulating a sql query without using temporary tables:
table A contains the following columns:
buy_currency sell_currency buy_amount sell_amount
The final answer should be:
The actual query will be a sum of all currencies grouped by currency.
Any suggestions will be helpful.
Thanks.
JPY USD 100. 1.00
USD JPY 2.00 200.
currency buy_amt sell_amt
JPY 100. 200.
USD 2.00 1.00
AG