>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.