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