a better statement
update account_analytic_line as l set to_invoice= (select a.to_invoice from account_analytic_account a where a.id=l.account_id ) ;
a better statement
update account_ analytic_ line as l analytic_ account a
where a.id=l.account_id )
set to_invoice= (select a.to_invoice from account_
;