Dear all,
Here I have a query...
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 feilds 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
--
Ratna Rajesh Thangudu
Research Scholar
Laboratoire de Biochimie et G�n�tique Mol�culaire
Universit� de La R�union
15 avenue Ren� Cassin, BP 7151
97715 Saint Denis Messag Cedex 09
La R�union, France
Tel : +262 262 93 8641
Fax : +262 262 93 8237
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
