>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_'
>>