simple create view sql help needed please.
From: <thajman_at_yahoo.com>
Date: Wed, 23 Jan 2002 23:43:27 GMT
Message-ID: <3c4f4959.82942335_at_news-central.giganews.com>
Date: Wed, 23 Jan 2002 23:43:27 GMT
Message-ID: <3c4f4959.82942335_at_news-central.giganews.com>
I am trying to create a summary view of some general ledger accounting
data.
Basically I would like the total debits (sum of gdet_amount >0) and
credits (sum of gdet_amount <0) for each account (gdet_account)
I am obviously an inexperienced SQL person and would appreciate one of
you gurus helpimg me out! I have tried many different things and have
come up empty.
TIA!