>>Hi,
>>
>>I am always concerned when I need to create a SQL Update evolving SQL Select with join.
>>
>>Here is a pseudo syntax
>>
>>

>>
>>*--  I need to update the column eqpmsch.month_week and set it to 1 where it is greater than 1.
>>
>>*-- The following SQL Select will select the rows I need to update. 
>>select eqpmsch.month_week  from eqpmsch join pm_task on pm_task.task_no = eqpmsch.task_no 
>>where pm_task.freq = 12 and eqpmsch.month_week > 1
>>
>>*-- This is my attempt at creating a SQL Update
>>update eqpmsch set month_week = 1 where select eqpmsch.month_week  from eqpmsch join pm_task on 
>>pm_task.task_no = eqpmsch.task_no where pm_task.freq = 12 and eqpmsch.month_week > 1
>>
>>

>>
>>I get error near the key word SELECT (in the SQL Update above). How do I change it?
>>
>>TIA
>>
>>UPDATE. The following syntax does not have an error:
>>

>>update eqpmsch set month_week = 1 from eqpmsch join pm_task on 
>>pm_task.task_no = eqpmsch.task_no where pm_task.freq = 12 and eqpmsch.month_week > 1
>>

>>
>>I am still not 100% sure if the above is the correct syntax. Please let me know.
>
>It is correct.

Thank you!