Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT a.GroupCD,a.GroupName,a.GroupParentCD,
( SELECT GroupName
FROM dbo.Bpm_OrganizationMiddle
WHERE GroupCD = a.GroupParentCD
) GroupParentCDName,a.is_delete
FROM dbo.Bpm_OrganizationMiddle AS a;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment