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
