Our team (AT:http://www.myf1.net/bbs/list.asp?boardid=1, which is the biggest foxer forum in china ) found this problem too, we find the way to solve this is: if you need to use the group clase, then you must add the group field to select clase, that means you can't use 'select * from' but code in all field name yourself!