[AccessD] A2000: DELETE query with JOIN

Gustav,

This database is inherited. It was created back in the mid-90s in
Paradox for Windows v. 5. I upgraded it to v. 8 without, to my shame,
revising the primary keys of any of the tables that use that 4-part
CAS key. Now I'm upgrading it again to Access.

All I can say is, this is one of those queries that Paradox handled
all right. I'm floored that I can't find a less cumbersome method in
Access.

OK, whatever sympathy I gained by my "inherited" story has just
evaporated with my invidious comparison to Paradox, eh?

Steve Erbach



On Mon, 14 Feb 2005 19:22:23 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> It is that it reveals you have no autonumber or similar primary key.
> On this list people have been killed for less (well, maybe not ...)
> 
> (Tip: Tell this database is inherited; then mood will shift towards
> great sympathy)
> 
> /gustav