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.

MSRUserGeoMapping

Data source: Amazon

select distinct u.UserAlias, g.BigAreaID, g.AreaId, g.RegionId, g.SubRegionId, g.SubsidiaryId from MSRUser u
left join UserSubsidiary us on u.UserID = us.UserId
left join [MSSales].[dbo].[GeographyHierarchy] g on us.SubsidiaryID = g.SubsidiaryId