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 @ 2018-07-20 16:22  纡ゾ少︶ㄣ  阅读(151)  评论(2)  编辑  收藏  举报