Multiple descriptions for same part number

R

rapid1

I have a db with 100k sku's in 165 locations. Each sku is supposed to have
the same description across all locations but some do not. I need to write a
query that will filter for only part numbers with more than 1 description
assigned. I was thinking I could do it with only the Part Number, Location
and Description fields? Anyway, any help would be much appreciated!
 
J

John W. Vinson

I have a db with 100k sku's in 165 locations. Each sku is supposed to have
the same description across all locations but some do not. I need to write a
query that will filter for only part numbers with more than 1 description
assigned. I was thinking I could do it with only the Part Number, Location
and Description fields? Anyway, any help would be much appreciated!

Any answer would require some understanding of your table structure. Where are
the descriptions stored? How are the tables related?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top