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!
Click to expand...

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