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.