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
