[AccessD] A2000: DELETE query with JOIN

Gustav,

Yes, that's something I did try; that is, removing the JOINs and going
with the WHERE clause only. No dice.

I don't recall where that consitent/inconsistent updates thing is.

Steve Erbach


On Mon, 14 Feb 2005 20:29:31 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> I find it a pity that competition fades away.
> 
> By the way, couldn't you do it without the NOT IN (...) or temp table
> by - in your original attempt - not using joins but a simple WHERE
> S.CAS1<>T.CAS1 AND S.CAS2<>T.CAS2 AND etc.?
> Also, did you try the consistent/inconsistent updates setting?
> 
> /gustav
>