>Ok.
>
>Why not?
>
>>>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_'
>>>

>>
>>But this cannot work.

You cannot use commits.oldetype
because commits doesn't belong to the set of FROM tables.