Exactly what you are saying Mr. Sándor. I tried adding a recordamount of debt then becomes a multiple of 4. Well I'm really confused. Are there any who can help? how to call the databaseby entering on the right?
----- Original Message ----- From: HaidarPesebe To: MySQL Lists Sent: Friday, July 29, 2011 10:48 AM Subject: results from a total of always amount to a multiple of 3 I experienced a unique problem, after I call the database as follows: SELECT id, concat(period,'-',semester) as periodsmester, sum(qty) as qtyone, sum(bqty) as qtytwo FROM pay a INNER JOIN debt b on (a.name=b.uname AND a.period=b.bperiod AND a.semester=b.bsemester) WHERE name='jon' group by concat(period,semester) order by period ASC, semester ASC but results from a total of always amount to a multiple of 3. should total qty (USD) pay = 8 but the result would be 24. so also for the Debt. Please help. Such databases DB 1 = pay id | name | period | semester | qty(USD) ---------------------------------------------------------------- 1 | jon | 2010-2011 | 1 | 2 2 | jon | 2010-2011 | 1 | 1 3 | jon | 2010-2011 | 1 | 3 4 | jon | 2010-2011 | 1 | 2 DB 2 = Debt did | uname | bperiod | bsemester | remark | bqty(USD) --------------------------------------------------------------------------------- 1 | jon | 2010-2011 | 1 | paper | 7 2 | jon | 2010-2011 | 1 | mouse | 4 Thanks, Haidarpesebe __________ Information from ESET NOD32 Antivirus, version of virus signature database 6333 (20110728) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 6339 (20110731) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 6339 (20110731) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com