THANKS FOR THE FAST REPLY OMAR
On 12/10/07, Amy Bensinger (Contractor) <[EMAIL PROTECTED]> wrote: > > Here you go: > > > > select cs.description, count(*) from customer c > > join customer_state cs on c.status_id=cs.status_id > > group by cs.description; > > > > > > > > Mifos.org <http://mifos.org/> has a page on data base development, > including links to the schema diagrams: > > > http://mifos.org/developers/technical-orientation/mifos-database-development#database-schema-diagram > ------------------------------ > > *From:* [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] *On Behalf Of *omar bilani > *Sent:* Monday, December 10, 2007 6:13 PM > *To:* [email protected] > *Subject:* [Mifos-developer] get the inactive customers list > > > > Hi, > > any one know the tables that i need to check in order to get a list of all > the customers and their status (active, closed, blacklisted..) > > also if there is a map or a document that describe the database it would > be great, since i am now checking all the tables one by one.. > > thanks > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php >
------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php
