I have the following query which returns the GroupID, GroupName, UserID, UserName and UserEnabled results.
GR.GROUPID as GroupID,
GR.FULLNAME as GroupName,
DU.USERID as UserID,
DU.FULLNAME as UserName,
DU.LOGIN as UserEnabled
from mhgroup.GROUPMEMS GM
join mhgroup.GROUPS GR on GR.GROUPNUM=GM.GROUPNUM
join mhgroup.docusers DU on DU.USERNUM=GM.USERNUM
where GR.GROUPID in ('1407 - SLR Users')
order by GROUPID
I need to modify this QUERY into 1 or 2 queries to :
Insert a new GroupID called ' 1405 - SLR Users' ; and
then insert new values into the UserID column for this new group.
Thanks in advance