Ready to get started with anonymous questions today? It's easy! Learn more.
SELECT LL.StoreLocationID ,LC.[StoreID] ,ISNULL(LC.CityID,0) CityID ,ISNULL(C.CityTypeName,'All City Types') CityTypeName ,ISNULL(LL.RegionName,'All Regions') RegionName ,L.[Name] StoreName ,ISNULL(C.Name,'All Cities') AS CityName ,ISNULL(S.Name, 'All States') AS StateName FROM [StoreCity] LC INNER JOIN [Store] L ON L.[StoreID] = LC.[StoreID] INNER JOIN [StoreLocation] LL ON LL.StoreID=LC.StoreID LEFT OUTER JOIN [City] C ON LC.CityID = C.CityID LEFT OUTER JOIN [State] S ON C.StateID = S.StateID where StoreLocationID = 71
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.