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