Skip to Content (Press Enter)
UserImage.jpg
Diogo Nesbitt
3Views
2Comments
Advanced Query
Question
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.
0
0
20 Apr 2008
Copy Link
2019-10-09 06-46-56
Daniel Lourenço
Staff
Hi Diogo,

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

Best Regards,

Daniel Lourenco
0
0
21 Apr 2008
Copy Link
UserImage.jpg
Diogo Nesbitt
Tes It works... but why the warnings...
0
0
21 Apr 2008
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.