I have a table of data (table name = test):
item No Sls Cat
A 1 HI
B 2 HI
B 3 NI
C 4 HI
The reuslts I want are:
The results should contain all the items in which an HI appears in the group. The results are grouped by ItemNo.
A qualtifies becuase it only contains an HI
B qualifies because it contains at least one HI
C does not qualify because its group does not contain any HIs.
I have attached code to create the table and populate it.
Thanks in advance for your help.