2 concat('cn=',c.categorycode,',ou=',c.categorycode,',dc=ffzg,dc=hr') as dn,
3 'group' as objectClass,
6 description as description,
8 concat('uid=',replace(userid,'@ffzg.hr',''),',ou=',c.categorycode,',dc=ffzg,dc=hr') as members
10 join borrowers b on b.categorycode = c.categorycode
11 where length(userid) > 0