GROUP BY in CFC for Bound CFSELECT

Posted 03 April 2014 - 01:13 PM

I am trying to bind two CFSELECTS which works. In the updater.cfc I have the following query that works but I want to add GROUP BY ValtblJobs.Job so that my CFSELECT has only one instance of the many records fed to it. I have tried adding the group by several times but get an error executing the query.