I am sorry but I searched everything on the forum but cant find an answer on a simple question.
I am using the add-on cbquery. Now I want to make a dingle select dropdown field of names of certain users. I made this query:

SELECT `gastoudervoornaam` FROM `#__comprofiler` WHERE `cb_organisatienummer` = 'ID';

When I try the dropdown field, I don't see any values. What am I doing wrong?

Note: Already found the solution. The comprofiler table had a different name. This can be closed.