Advanced Query

  
Hello

in the advanced query

SELECT TOP 10 {Staff}.* ,COUNT(*) as c
FROM ((({Category} ENCategory Inner JOIN {Staff} ON ({Staff}.[ID] = ENCategory.[STAFF_ID]))
Inner JOIN {State} ENState ON ({Staff}.[STATE_ID] = ENState.[ID]))
GROUP BY {Staff}.*
ORDER BY c DESC

if I press the verify button i will take 2 errors,
"Unexpected 10 in ..."
"Unexpected {Staff}.*" in group by

but if I run the program it works. so the problem is in the service studio.
Hi Diogo,

I suppose you're getting warnings only. If you press the test query, doesn't it work?

Best Regards,

Daniel Lourenco
Tes It works... but why the warnings...