I need to list our values from Table A that are not in Table B. Table A contains a list of all attributes and their values from products. These attribute values need to be compared to table B which just contains a list of all valid values for each attribute. Each value in table A is listed a separate column; Value1; Value 2; Value3 and Value 4. Each of these values from each of these columns needs to be compare with Table B and then report the values not found in a vertical alignment when each attribute and value are a separate row.
Table A (List of Products with values)
AttributeID Value 1 Value2 Value3 Value4
Color Black White Pink
MaterialType Wood Plastic
Finish Glossy Satin Other
Table B (List Valid Values)
AttributeID AttributeValue
Color Black
Color Blue
Color Orange
MaterialType Plastic
Finish Satin
Finish Primed
Report Expectations (only list the attribute values not found in table B)
AttributeID Value
Color White
Color Pink
MaterialType Wood
Finish Glossy
Finish Other
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.