Re: Purge records that don't have a relationship

(To OP)

Yep. I bet this is the one which does the trick.

Regards,
Paul

"Peter Sylvester" <peters_no_spam_please_at_mitre.org> wrote in message news:c6p3jh$72g$1_at_newslocal.mitre.org...
> You don't mention what is happening in terms of "choking", but you might
> want to try something like the following:
>
> DELETE FROM OCCWORD WHERE PKREF IN
> (SELECT PKREF FROM OCCWORD MINUS SELECT FKREF FROM OCCSRC);
Received on Fri Apr 30 2004 - 14:26:19 CDT