Multiple descriptions for same part number

  • Thread starter Thread starter rapid1
  • Start date Start date
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!
 
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!
Click to expand...

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