select personalbasic.number,personalbasic.name,personalbasic.position,personalbasic.politics,
personalbasic.code,personalbasic.addr,
homemen.appellation,homemen.name,homemen.code,homemen.phone,homemen.unit
from personalbasic,homemen
where personalbasic.number=homemen.number  
and appellation='父亲' and personalbasic.grade=7 into outfile 'p1.xls';

select appraise.total,appraise.remark,personalbasic.number,personalbasic.name
from appraise,personalbasic where appraise.number=personalbasic.number and personalbasic.grade=5 and appraise.termid=3 into outfile 'p2.xls';

select personalbasic.number,personalbasic.name,loan.flag,loan.year,loan.money
from personalbasic,loan
where personalbasic.number=loan.number and personalbasic.grade=4 and loan.time like '2007%' 
into outfile 'loan3.xls';

select personalbasic.number,personalbasic.name,award.item1,award.item2
from personalbasic,award
where personalbasic.number=award.number and personalbasic.grade=7 and award.time like '2007%'
into outfile 'award.xls';