CB Query field

I want to make a single select query field where I can choose users from a certain usergroup:

SELECT `a.id`,`a.name`,`b.user_id`, `b.group_id` FROM `#__users`, `a` INNER JOIN `#__user_usergroup_map`, `b` ON `a.id` = `b.user_id` WHERE `b.group_id` LIKE `17` ORDER `a.name` ASC

The above works in a Joomla db query, but it throws an error in the CB query field - why ?

That query is not valid. It has syntax errors and escaping errors. Joomla likely is just not throwing an error. CB does not suppress errors as it's bad practice and prevents you from knowing when something is wrong. The below is valid.


See the below for SQL resources on how to write valid SQL.

www.w3schools.com/sql/default.asp
dev.mysql.com/doc/refman/5.6/en/tutorial.html

Thank you!