RB Smissaert <[EMAIL PROTECTED]>
wrote:
Trying to delete rows in a SQLite table where
One particular field has a duplicate value.
Tried this query, using a self-join:
DELETE
FROM
table1 t1 INNER JOIN table1 t2 ON
(t1.fieldB = t2.fieldB)
WHERE
t1.OID <> t2.OID
But I get an error near t1
delete from table1
where exists (
select * from table1 t2
where table1.fieldB = t2.fieldB and table1.OID <> t2.OID
);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------