如何组合没有公共列字段的两个表？

  ;WITH K_RT_MasterRetailStoresTable (CommonId,Branch) AS
(
SELECT ROW_NUMBER() OVER(ORDER BY Branch) AS CommonId,Branch
FROM K_RT_MasterRetailStores
 )
 ,K_BR_AddBranchTable (CommonId, branch) AS
 (
SELECT ROW_NUMBER() OVER(ORDER BY branch) AS CommonId,branch
FROM K_BR_AddBranch
 )
 ,K_HM_BranchTable (CommonID,branch) as
(
SELECT ROW_NUMBER() OVER(ORDER BY branch) as CommonId,branch
FROM K_HM_Branch
 )
,k_Master_BranchesTable (CommonID, branch) as
 (
 SELECT ROW_NUMBER() OVER(ORDER BY BRANCH) AS COMMONID,BRANCH
FROM k_Master_Branches
 ) 
  SELECT MRS.BRANCH,AB.BRANCH,B.BRANCH,MB.BRANCH 
  FROM K_RT_MasterRetailStoresTable MR
  LEFT OUTER JOIN K_BR_AddBranchTable AB ON MR.COMMONID = AB.COMMONID 
  LEFT OUTER JOIN K_HM_BranchTable B ON AB.COMMONID = B.COMMONID 
  LEFT OUTER JOIN k_Master_BranchesTable MB ON B.COMMONID = MB.COMMONID
  ;WITH K_RT_MasterRetailStoresTable (CommonId,