| select a.*, b.*,c.region,max(d.ARRIVAL_DATE) from uf_contract a left join uf_contractitem b on a.id = b.contract_id LEFT JOIN UF_REGION c ON a.ID = c.ID left join uf_PROJECT_ARRIVAL d on a.ID=d.ID 我想把b表，c表的region还有d表的最大值ARRIVAL_DATE都插入到a表 ，底下是plsql的报错，请问该怎么写？  |
