|
desde ya muchas gracias por contestar, no me funciono,
DELETE * FROM base WHERE base.id IN (SELECT DISTINCTROW base.id FROM base
WHERE (((base.id) In (SELECT [id] FROM [base] As Tmp GROUP BY [id] HAVING Count(*)>1 )))
ORDER BY base.id)
lo adapte a mi base de datos y campos y no funciono, pero desde ya agradezco tu atencion
hugo
|