以保险公司为基表进行左联接查询：select i.company,p.id ,i.* from insurance i left join insure pi on i.company = pi.company left join patient p on pi.id = p.id
