i need to update the record in table line .but i have to map the specific line record using line_esn ,account,company_number_loc .but in update we can pass only one table like update "tablename".
How could i do that.......


update line_esn le, line l, account a, company_number_location cnl
set l.pin =8351
where le.line_id = l.line_id
and le.mdn = '4042108351'
and le.esn = '09900311161'
and cnl.company_cd = 'REVASDATA'
and a.number_loc = cnl.number_loc
and a.account_id = l.account_id