[AccessD] A2000: DELETE query with JOIN

Gustav,

Oh, for heaven's sake! I mis-read Mr. Beckles' post. When I use

DELETE DISTINCTROW T1.*

THEN it works...and without having to have a primary key in either
table! This has been a long way around to get to this point. I can't
say as I've ever used DISTINCTROW.

My apologies, David. You were right.

Steve Erbach


On Sat, 19 Feb 2005 16:02:44 +0100, Gustav Brock <Gustav at cactus.dk> wrote:
> Hi Steve
> 
> First, DISTINCT is not the same as DISTINCTROW.
> Second, using DISTINCT you can't just select all (*), you have to
> specify the fields to select.
> 
> /gustav