me estoy volviendo loco, les comento
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)
esto en access funciono, contra sqlserver (microsoft V7) no funciona, si alquien puede saber algo les encargo
gracias
hugo
|