Hi MS Access & MS SQL Server Gurus !
I am trying to delete duplicate data from a LINKED SQL Server 2000
table (LinkedTable) and insert the result into a local (in Access)
table.
The following code works in SQL Server 2000 but NOT in Access, could
any one tell me what's wrong with it?
SELECT a.id, a.change_id AS chgid, a.Action_desc as Actiondescr INTO
LocalTable
From dbo.LinkedTable as a
Where a.id = (
Select TOP 1 b.id
From dbo.LinkedTable as b
Where a.change_id = b.change_id
Order By b.time_stamp)
Thanks in advance !