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