Re: results from a total of always amount to a multiple of 3

2011-08-02 Thread Hal�sz S�ndor
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 joint? That is not

Re: results from a total of always amount to a multiple of 3

2011-07-31 Thread 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? - Original Message - From: HaidarPesebe To: MySQL Lists Sent:

Re: results from a total of always amount to a multiple of 3

2011-07-29 Thread Hal�sz S�ndor
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 total qty (USD) pay? It is better exactly to repeat your code instead of

results from a total of always amount to a multiple of 3

2011-07-28 Thread HaidarPesebe
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