Hi I managed to create this update query in microsoft access with the below sql code:-

Two tables Des Ref and Des Ref2 are linked via Inner Join because I only want to update certain values in the Des Ref table. The Endate field in Des Ref table will be updated to 05/25/2007 where there is a match.


Code:
UPDATE [Des Ref] INNER JOIN [Des Ref2] ON [Des Ref].Desref = [Des Ref2].[Des ref] SET [Des Ref].Enddate = #5/25/2007#;

How do I do the same in SQL server 2000? Whats the simple code?

Cheers,