SQL Query Export Product Categories

[joecalardo]

Hello, I am trying to figure out which of my products I have in my store that are not mapped, I feel like I have well over a few hundred that havn't been mapped over the months. I'd like a query to pull the products that are mapped, to show me what category they are in and I want to show the products that do not currently have a mapping as well. Thank you.

[esedirect]

select p.ProductID, p.Name, pc.CategoryID, c.Name
from Product as p (nolock)
left join ProductCategory as pc (nolock) on p.ProductID=pc.ProductID
left join Category as c (nolock) on pc.CategoryID=c.CategoryID
order by 3,1

The non-mapped ones will be at the top of the list with nulls for pc.categoryid and c.name.

You'll probably want similar for the other entities, eg distributor, section, etc. if you use them