Thanks Sergey (Thats Sergey, with an 'S')



>Try

>UPDATE mod
>	SET accttype = '', e_type = commits.oldetype
>	FROM media_order_detail mod
>	JOIN commits ON commits.id = mod.id
>		AND commits.statname = 'WFSB' and commits.invoiceid = '86883-2_'
>

>>I'm trying to work out this update
>>
>>Is this the most efficient way to do this?
>>
>>

>>UPDATE media_order_detail
>>  SET accttype = '',
>>      e_type = commits.oldetype
>>   where id in
>>    (select id
>>      from commits
>>      where statname = 'WFSB' and invoiceid = '86883-2_'
>>