CROSS JOIN

 select a.GM_Name as 名称,a.GM_Code 代码,b.DC_Code as 上级,b.DC_LVL as 排序  from HIS_Pubdata..Tbl_Dic_DeptGroupMethod  as a   CROSS JOIN HIS_Pubdata..Tbl_Dic_DeptCategory as b  where a.ZDLevel=''

效果

 

posted @   纡ゾ少︶ㄣ  阅读(152)  评论(2编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示