Need Help SQL query

From: <rahulbindlish_at_gmail.com>
Date: 10 Jun 2006 08:20:17 -0700
Message-ID: <1149952817.628910.142020@g10g2000cwb.googlegroups.com>

Hi,

I have to search in database in which structure of table is like this:-

---

Col 1(Foreign Key) Col 2 Col3 Col4(Primary Key)

---

1                               fruit              apple      1
1                               fruit              mango    2
1                              fruit               banana   3

2                              vegetable       potato   4
2                              vegetable       tomato  5
...................................................................................................

Now I have to write a query to find out Col1 if Col2 is "fruit" and Col3 contains only and only those elements that are in "where" parameter.

Thanks in advance
Regards,
Rahul Received on Sat Jun 10 2006 - 10:20:17 CDT