Sum DISTINCT

2006-10-16 Thread Alvaro Cobo
Dear friends: I have two tables. In one of those I store information about loans and the year it was given. The other one stores the families which have received this loans, with infromation abot the number of members in each family (male and women). Each family can receive more than one loan in

How to handle sum(distinct field name) ???

2001-12-25 Thread aravind gorthy
Hai, Could any one tell me how to handle sum(distinct fieldaname) concept in MySQL 3.23.40. thanks in advance. Aravind = Aravind Gorthy, VisualSoft Technologies. For Stock Quotes, Finance News, Insurance, Tax Planners