[AccessD] A2000: DELETE query with JOIN

David Beckles becklesd at tiscali.co.uk
Thu Feb 17 14:00:46 CST 2005


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




More information about the AccessD mailing list