2011/08/01 09:48 +0700, HaidarPesebe
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?
What do you want from the jo
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
>>>> 2011/07/29 10:48 +0700, HaidarPesebe >>>>
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.
<<<<<<<<
What do you mean "total of", and "
7;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
