>>Hi everybody,
>>
>>I'm trying to understand UPDATE FROM syntax and see, if I can apply it.
>>
>>Here is what I have
>>

>>select cEmployee_Queue_Schedules_pk ;
>>		from Trans inner join Trans_Employees_Queues TEQ ;
>>		on Trans.cTrans_pk = TEQ.cTrans_fk ;
>>		inner join Employee_Queue_Schedules EQS ;
>>		on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ;
>>		where not Trans.cResolution_Codes_fk is null ;
>>		and EQS.iActive_Flag = 1 into cursor curResolvedAccts
>>		
>>		update Employee_Queue_Schedules set iActive_Flag = 0 ???
>>

>>
>>I want to update all records in Employee_Queue_Schedules that have matching records in curResolvedAccts.
>
>

>
> update EQS set iActive_Flag = 0 ;
>		from Trans inner join Trans_Employees_Queues TEQ ;
>		on Trans.cTrans_pk = TEQ.cTrans_fk ;
>		inner join Employee_Queue_Schedules EQS ;
>		on TEQ.cTrans_Employees_Queues_pk = EQS.cTrans_Employees_Queues_fk ;
>		where Trans.cResolution_Codes_fk is not null ;
>		and EQS.iActive_Flag = 1
>

Thanks a lot.