Hi,

I have a table data like this

unique_id, journal_no, account_id, debit, credit
1 1 242 200.00 0.00
2 1 234 250.00 0.00
3 1 522 450.00

4 2 525 500.00 0.00
5 2 219 0.00 100.00
6 2 423 0.00 200.00
7 2 332 0.00 200.00

account_id will never repeat under a journal_no.
Either
debit or credit will have only one entry.

Please help me to write a SELECT statment which
returns
the account_id of the amount which is appearing as a
total to the multiple entries ( account_id 522 and
525 in this example).

Thank you.

Sudheer


________________________________________________________________________
Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs
http://www.yahoo.co.uk/robbiewilliams