We help IT Professionals succeed at work.

SQL Select - identify record discrepancies

tmajor99
tmajor99 asked
on
94 Views
Last Modified: 2017-04-06
I need some help with SQL Select to identify record discrepancies.  I have a table containing a list of products with each product containing 3 feature descriptions.  I also have a group ID column that groups related sets of products together.  WIthin each product group, I need to identify the group of products that do not contain the same set of new features.    For example;

GroupID  Product ID NewFeature01 NewFeature02 NewFeature03
  1                  21                   Apple            Peach
  1                  22                   Peach            Apple
  1                  23                                          Peach               Apple
  2                  24                    Cherry
  2                  25                    Orange  
  3                  26                                          Nuts
  3                  27                     Nuts

Using the above example, only product group does not have the same set of new features.   Therefore, the expect result from this SQL Select query would:
GroupID  Product ID NewFeature01 NewFeature02 NewFeature03
  2                  24                    Cherry
  2                  25                    Orange
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION