select pub_sysinit.pk_sysinit, pub_sysinit.pk_corp, pub_sysinit.sysinit, pub_sysinittemp.sysindex, pub_sysinit.initcode, pub_sysinit.initname, pub_sysinit.makedate, pub_sysinit.value, pub_sysinit.editflag, pub_sysinit.controlflag, pub_sysinit.pkvalue, pub_sysinittemp.remark, pub_sysinittemp.defaultvalue, pub_sysinittemp.valuelist, pub_sysinittemp.stateflag, pub_sysinittemp.domainflag, pub_sysinittemp.paratype, pub_sysinittemp.valuetype, pub_sysinittemp.sysflag, pub_sysinittemp.groupcode, pub_sysinittemp.mut exflag, pub_sysinittemp.mainflag, pub_sysinittemp.jzflag, pub_sysinittemp.showflag, pub_sysinittemp.groupname, pub_sysinittemp.checkclass, pub_sysinittemp.editclass, pub_sysinittemp.corpflag, pub_sysinittemp.dataclass, pub_sysinittemp.afterclass
from pub_sysinit
inner join
select pub_sysinittemp ON pub_sysinit.sysinit = pub_sysinittemp.pk_sysinittemp