合并范围-合并单元对应查询SQL

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

合并范围-合并单元对应查询SQL

```language SELECT T1.FNUMBER "合并范围编码",T1.FNAME_L2 "合并范围名称",T2.FNUMBER "组织编码",T2.FNAME_L2 "组织名称",T0.FLONGNUMBER "组织长编码",T0.FDISPLAYNAME_L2 "组织长名称" FROM T_ORG_STRUCTURE T0 LEFT JOIN T_ORG_Tree T1 ON T0.FTREEID = T1.FID INNER JOIN T_ORG_BASEUNIT T2 ON T0.FUNITID = T2.FID WHERE T0.FTREEID = (SELECT TOP 1 FID FROM T_ORG_Tree where FNUMBER ='01' order by FSTARTDATE DESC) ORDER BY T0.FLongNumber ASC ```

合并范围-合并单元对应查询SQL

```languageSELECT T1.FNUMBER "合并范围编码",T1.FNAME_L2 "合并范围名称",T2.FNUMBER "组织编码",T2.FNAME_L2 "组织名称",T0.FLONGN...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息