RE: SQL delete not in related table

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

> Try this:
> 
> delete
> from podtl A
> where exist ( select 1 
>               from pohdr B
>               where A.vndnr = B.vndnr
>                 and A.weekx = B.weekx
>                 and A.digit = B.digit
>             )

It doesn't like that either.  Says the "1" is not valid.  Also, why do you
say "WHERE EXIST" instead of "WHERE NOT EXIST"?