Multiple Group Query

[gevensen]

is it possible to do a multiple group query such as below

I get all returned in one group with different fund accounts and projects no group is made?

 

SELECT sum(amount), bank_account, fund, account, project FROM sc_allocated_funds WHERE expense_id IS NOT NULL GROUP BY fund AND account AND project

[premiso]

It all depends on the structure of the data, but I think your GROUP BY is flawed, not sure if AND is valid syntax?

 

GROUP BY fund, account, project

 

I think commas need to be used. I am not 100% sure on that but yea. If there is a unique field being returned then the group by will not work. Such as the primary key etc. If the all the items are not unique then it should work and group them.

[gevensen]

i get mysql error with commas

[PFMaBiSmAd]

We cannot really help you with the mysql error you got unless you post it. Posting the current query would help as well.

 

The GROUP BY term that  premiso posted is correct syntax.

[gevensen]

ok my mistake

 

i changed sum(amount) to amount in the 1st part and it only showed the 1st line out of 8

 

SELECT amount, bank_account, fund, account, project FROM sc_allocated_funds WHERE expense_id IS NOT NULL GROUP BY fund , account , project

 

when I changed it back to sum(amount) it worked, maybe when i did it the other day manually i hit a wrong digit as myphp admin sql is small even on my 28 in monitor

 

SELECT sum(amount), bank_account, fund, account, project FROM sc_allocated_funds WHERE expense_id IS NOT NULL GROUP BY fund , account , project

 

much thanks for the help the AND was wrong and the comma was right!

[gevensen]

as i would have written on a afto form 349 in the military many moons ago "short between headset repaired short"