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.VVALIDITYVALUE
WHERE (CATEGORY_ID = 2)

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

SELECT VALUE_ID
FROM CC000.VSCREENVALUE
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]

Try this one:

SELECT VALUE_ID
FROM CC000.VVALIDITYVALUE T1
WHERE (CATEGORY_ID = 2)
AND NOT EXISTS ( SELECT *
FROM CC000.VSCREENVALUE T2
WHERE (SCREEN_ID = 'CCL100')
AND (CATEGORY_ID = 2)
AND T1.VALUE_ID = T2.VALUE_ID )

"Binu Jacob" <bj*******@msn.com> schreef in bericht
news:3f*********************@news.frii.net...

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

SELECT VALUE_ID
FROM CC000.VVALIDITYVALUE
WHERE (CATEGORY_ID = 2)

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

SELECT VALUE_ID
FROM CC000.VSCREENVALUE
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!