[sqlite] Deleting rows with duplicate in one field

[RB Smissaert]

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

Any suggestion what I am doing wrong here?

RBS





-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------