SQL QUERY

[Binu Jacob]

Hi; I need some help in writing a query and the following is what I am
trying to do.

SELECT VALUE_ID
FROM CC000.VVALIDITY VALUE
WHERE (CATEGORY_ID = 2)

The above Query will give will every Value_ID where the Category_ID =2.
Then

SELECT VALUE_ID
FROM CC000.VSCREENVA LUE
WHERE (SCREEN_ID = 'CCL100') AND (CATEGORY_ID = 2)

The above one will give me all Value_ID where the Screen_ID = 'CCL100'
AND Category_ID = 2. Now, what I really want is every Value_ID from the
First Query except the ones from the Second Query.

So, Please help me out

Thanks
Binu

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Robert de Jager]

Re: SQL QUERY

Try this one:

SELECT VALUE_ID
FROM CC000.VVALIDITY VALUE T1
WHERE (CATEGORY_ID = 2)
AND NOT EXISTS ( SELECT *
FROM CC000.VSCREENVA LUE T2
WHERE (SCREEN_ID = 'CCL100')
AND (CATEGORY_ID = 2)
AND T1.VALUE_ID = T2.VALUE_ID )

"Binu Jacob" <bjmphilip@msn. com> schreef in bericht
news:3f044465$0 $204$75868355@n ews.frii.net...[color=blue]
> Hi; I need some help in writing a query and the following is what I am
> trying to do.
>
> SELECT VALUE_ID
> FROM CC000.VVALIDITY VALUE
> WHERE (CATEGORY_ID = 2)
>
> The above Query will give will every Value_ID where the Category_ID =2.
> Then
>
> SELECT VALUE_ID
> FROM CC000.VSCREENVA LUE
> WHERE (SCREEN_ID = 'CCL100') AND (CATEGORY_ID = 2)
>
> The above one will give me all Value_ID where the Screen_ID = 'CCL100'
> AND Category_ID = 2. Now, what I really want is every Value_ID from the
> First Query except the ones from the Second Query.
>
> So, Please help me out
>
> Thanks
> Binu
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]