Dear All,
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi 14
1nmi 14
1oo3 14
1oo3 14
1oo4 14
1oo4 14
I want to select those rows with 'size' 14, 32 and 37. This is easy..but I
also want only those uniq codes which have all the 'size' (14,32 and 37)
associated with it. Please note that none of the fields are uniq.
Here in this case I want result like
1n3j 14
1n3j 32
1n3j 37
1nm4 14
1nm4 37
1nm4 32
because 1n3j and 1nm4 are the only two codes which have all the 'size's
requested ie., 14,32, 37.
Hope my question is clear.
Any kind of help is highly appreciated.
Best
Rajesh
my table looks like this :
code size
1n3j 14
1n3j 32
1n3j 37
1n9j 14
1n9j 32
1n9j 14
1nm4 14
1nm4 37
1nm4 32
1nmi 14
1nmi 14
1oo3 14
1oo3 14
1oo4 14
1oo4 14
I want to select those rows with 'size' 14, 32 and 37. This is easy..but I
also want only those uniq codes which have all the 'size' (14,32 and 37)
associated with it. Please note that none of the fields are uniq.
Here in this case I want result like
1n3j 14
1n3j 32
1n3j 37
1nm4 14
1nm4 37
1nm4 32
because 1n3j and 1nm4 are the only two codes which have all the 'size's
requested ie., 14,32, 37.
Hope my question is clear.
Any kind of help is highly appreciated.
Best
Rajesh