Skip to content

Instantly share code, notes, and snippets.

@Tesla9527

Tesla9527/sql 拼接字段

Created December 18, 2015 07:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Tesla9527/af8bf321692a94870e81 to your computer and use it in GitHub Desktop.
Save Tesla9527/af8bf321692a94870e81 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql 拼接字段
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