Re: DELETE where syntax ... need help :)



I want create a delete statement of this select result:

SELECT A.NAME, A.TYPE, A.TAG FROM PMTOOLS A
WHERE EXISTS (SELECT B.NAME, B.TYPE, B.DATABASE FROM PMTOOLS B WHERE
A.TAG != B.TAG)
ORDER BY A.NAME

.