Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

MSRUserBusinessMapping

Data source: Amazon

select distinct u.UserAlias, b.BusinessID, r.RevSumCategoryID from UserBusiness u
inner join [MSSales].[dbo].[Business] b on u.BusinessID = b.BusinessID
inner join [MSSales].[dbo].[BusinessSummary] s on b.BusinessSummaryID = s.BusinessSummaryID
left join [MSSales].[dbo].[BusinessDefinition] d on b.BusinessID = d.BusinessID
left join [MSSales].[dbo].[RevSumCategory] r on d.RevSumCategoryID = r.RevSumCategoryID