在写左关联时SQL语句出现 Duplicate column name 'NAME'名字重复错误解决方法

 SELECT * 
          FROM `personrequireupdate` a LEFT JOIN (select p.*,o.officeid,o.name as officename from person_modifyinf p
          LEFT JOIN office o   on o.officeid=p.officeid)p  ON p.personId=a.personId 
          LEFT JOIN personrole p2 ON a.personId = p2.personid 
          WHERE a.state=0 and p.state=0

SELECT * 
          FROM `personrequireupdate` a LEFT JOIN (select p.*,o.officeid ,o.name as officename from person_modifyinf p
          LEFT JOIN office o   on o.officeid=p.officeid)p  ON p.personId=a.personId 
          LEFT JOIN personrole p2 ON a.personId = p2.personid 
          WHERE a.state=0 and p.state=0
> 1060 - Duplicate column name 'officeid'
> 时间: 0.083s

    SELECT * 
          FROM `personrequireupdate` a LEFT JOIN (select p.*,o.officeid AS offid,o.name as officename from person_modifyinf p
          LEFT JOIN office o   on o.officeid=p.officeid)p  ON p.personId=a.personId 
          LEFT JOIN personrole p2 ON a.personId = p2.personid 
          WHERE a.state=0 and p.state=0

SELECT * 
        
                 FROM `personrequireupdate` a LEFT JOIN (select p.*,o.officeid AS offid,o.name as officename from person_modifyinf p
          LEFT JOIN office o   on o.officeid=p.officeid)p  ON p.personId=a.personId 
          LEFT JOIN personrole p2 ON a.personId = p2.personid 
          WHERE a.state=0 and p.state=0
> OK
> 时间: 0.059s