[AccessD] A2000: DELETE query with JOIN

David,

I think you're talking about T-SQL. I'm trying to do this in A2000.

Steve Erbach


On Thu, 17 Feb 2005 20:00:46 +0000, David Beckles
<becklesd at tiscali.co.uk> wrote:
> Dear Steve,
> 
> I think that the problem is that you need DISTINCTROW in the query, like so:
> 
> DELETE DISTINCTROW T1.*
> FROM T1
> INNER JOIN T2
> ON (T1.CAS4 = T2.CAS4)
> AND (T1.CAS3 = T2.CAS3)
> AND (T1.CAS2 = T2.CAS2)
> AND (T1.CAS1 = T2.CAS1);
> 
> David Beckles