I need help with Triggers. mssql 2000

[Seboko]

I want a trigger to update the fields: field1, field2 and field3 of NewTable
whenever the same fields are updated in OldTable.


CREATE TRIGGER UpdateNewTable ON dbo.OldTable
after UPDATE
AS

Begin
update NewTable set
field1 = Inserted.field1,
field2 = Inserted.field2,
field3= Inserted.field3
where Id = Inserted.Id

End



But I get a message that "The column prefix 'Inserted' does not match with a table name".

Please help

[russell]

create trigger UpdateNewTable ON dbo.OldTable

after update
as

update NewTable
set field1 = i.field1,
field2 = i.field2,
field3= i.field3
from NewTable n
join inserted i
on i.id = n.id