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=''

效果