Ok, if I want to use group by, then I have to put every select field
afterwards to group by. But I do want to group by one field.
Hence
select workgroup,id from job group by workgroup,id;
would create groups of 1?
But I want to group by workgroups.
Sorry if my explanation is fuzzy.
A.