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!