select a.pe_usename,a.sc_id,a.username,a.idcard,a.sex,a.birth,
a.Native,a.residence,b.regdate,a.info_flag,a.ksh,c.tel1,c.tel2,c.bp,c.icq,c.http,c.email,
c.work_site,c.address,c.pc,c.other,a.marry,a.pephoto,a.source,a.faddress,a.stature,
a.avoir,a.nation,d.pe_desc,a.polity,e.edc_level,e.University,e.enroll_time,e.CollegeID,
e.ClassID,e.Student_No,e.Specialty1,e.Specialty2,e.study_story,e.ability_cert,e.px_story,
e.pyfs,a.tech_level,e.xy,e.Specialty1_is_bada,e.Specialty2_is_bada,e.Sc_Specialty1,e.Sc_Specialty2
from pe_base a,pe_log b,pe_contact c,pe_desc d,pe_edc e,#t bb
where a.PE_USENAME=bb.PE_USENAME and
a.pe_usename=b.pe_usename
and a.pe_usename=c.pe_usename and a.pe_usename=d.pe_usename
and a.pe_usename=e.pe_usename