SQL nối tùm lum

SELECT ExShopCode.RowNum RowNum,CorporationCode,ShopCode,CustomerCode,CustomerName,DeleteFlg,CreateDate,UpdateDate,CreateDateT,UpdateDateT
FROM (
SELECT ROW_NUMBER() OVER ( ORDER BY CorporationCode ASC, ShopCode ASC ) AS RowNum,M.CorporationCode CorporationCode,M.ShopCode ShopCode,
M.CustomerCode CustomerCode,MT.CustomerName CustomerName,M.DeleteFlg DeleteFlg,convert(varchar,M.CreateDate,111) CreateDate,convert(varchar,M.UpdateDate,111) UpdateDate,
M.CreateDate CreateDateT,M.UpdateDate UpdateDateT FROM M_ExchangeShopCode M INNER JOIN [得意先マスタ] MT ON CorporationCode='001'
AND M.CustomerCode=MT.CustomerID AND MT.CustomerName LIKE '%%' ) ExShopCode WHERE ExShopCode.RowNum BETWEEN 1 AND 20