Re: Need Help SQL query

Comments embedded.
rahulbindlish_at_gmail.com wrote:
> 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
> ...................................................................................................
>

Such original and descriptive column names.

> 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.
>

And you're haven't yet done this for what reason? Are you waiting for someone ELSE to do your assignment for you? Your wait will be long and fruitless.

> Thanks in advance

You're thanking people for what, exactly? No one in this group will be writing this query for you. I would seriously consider actually learning the SQL language, taking (and reading) your class notes, reading your text and asking your instructor for clarifcations with questions like this.

> Regards,
> Rahul

David Fitzjarrell Received on Sat Jun 10 2006 - 23:49:32 CDT