Re: [ADMIN] Please help me write this query or function

2001-12-12 Thread Masaru Sugawara
On Tue, 11 Dec 2001 23:54:45 +1100 (EST) Mr OCP <[EMAIL PROTECTED]> wrote: > Hi > > We have a table like follows: > > id, account_name, amount, action_type > > The amount field has both debit and credit entires and > action_type defines the type of transaction ( debit or > credit), debit entr

[ADMIN] Please help me write this query or function

2001-12-11 Thread Mr OCP
Hi We have a table like follows: id, account_name, amount, action_type The amount field has both debit and credit entires and action_type defines the type of transaction ( debit or credit), debit entries have negative '-' symbol before the amount. where there are multipble transaction for the