I have this Access update query

UPDATE [T_Parameter]
INNER JOIN [T_SetupSheetParametersDetail]
     ON [T_Parameter].ParameterID = [T_SetupSheetParametersDetail].ParameterID SET [T_SetupSheetParametersDetail].ListOrder = [T_Parameter].[ListORder]

That I am trying to make work on MS SQL 2000, but I get an error: Incorrect syntax near the keyword 'INNER'.

I have tried to re-write it several different ways, and still can't get it to work.

__________________
Mitch

Move your 'SET' statement just above your 'inner join'.
You also need a 'FROM' for inner join to work.

So, it should look like this:

UPDATE [T_Parameter]
SET [T_SetupSheetParametersDetail].ListOrder = [T_Parameter].[ListORder]

FROM [T_Parameter]
INNER JOIN [T_SetupSheetParametersDetail]
     ON [T_Parameter].ParameterID = [T_SetupSheetParametersDetail].ParameterID

Thanks, I actually needed to modify what you suggested becasue I failed to indicate which table I was updating, so it was switched in your example. The following worked:

UPDATE [T_SetupSheetParametersDetail]
SET [T_SetupSheetParametersDetail].ListOrder = [T_Parameter].[ListORder]

FROM [T_Parameter]
INNER JOIN [T_SetupSheetParametersDetail]
     ON [T_Parameter].ParameterID = [T_SetupSheetParametersDetail].ParameterID

Thanks a lot, I kept hitting my head trying to figure why the syntax was wrong.