Re: Need Help SQL query

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Sat, 10 Jun 2006 16:47:39 GMT
Message-ID: <Xns97DE63C2CBB08ianalvistahotmailcom@70.169.32.36>

rahulbindlish_at_gmail.com wrote in
news:1149952817.628910.142020_at_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.
>

So, proceed to do so.

Do you really expect us to do your home work assignment for you? Received on Sat Jun 10 2006 - 11:47:39 CDT