Hello,
I have two queries:
UPDATE EListHierarchy SET EListHierarchy.EListItemUserType = "C"
WHERE EListHierarchy.EListItemName in (SELECT EListItemName
FROM EListHierarchy
WHERE EListItemName NOT IN (SELECT distinct EListItemParentName FROM
EListHierarchy WHERE EListItemParentName IS NOT NULL));
- this query updates the column correctly
I just need all the others not retrieved by the select statement to be set to
R, so i just used the NOT IN statement:
UPDATE EListHierarchy SET EListHierarchy.EListItemUserType = "R"
WHERE (((EListHierarchy.EListItemName) NOT In (SELECT distinct
EListItemParentName FROM EListHierarchy WHERE EListItemParentName IS NOT
NULL)));
is this the correct approach? is there a more efficient way to do this
statement?
please help!!!
thanks,
lyanne
L y a n n e R h e e z a C. O n g
---------------------------------
Never miss a thing. Make Yahoo your homepage.
[Non-text portions of this message have been removed]
