Cacher is the code snippet organizer for pro developers

SELECT        CG.ChainGroupId AccountingGroupID
       ,MG.MSOGroupID WizmoGroupID
       ,MG.Name WizmoName
       ,CG.Description AccountingName
       ,MC.MSOCustomerID CustomerID
       ,MG.IsCorpCollect
FROM wizmo2005_11.dbo.MSOGroup MG
       JOIN wizmo2005_11.dbo.MSOCustomerGroup MC
         ON MG.MSOGroupID = MC.MSOGroupID
       JOIN Accounting_11.dbo.ChainCustomer CC
         ON MC.MSOCustomerID = CC.CustomerID
       JOIN Accounting_11.dbo.ChainGroup CG
         ON CC.ChainGroupID = CG.ChainGroupId
ORDER BY CC.ChainGroupID