復合語句查詢: select id ,moduleid,(select nickname from users where users.userid=cjob.userid) userid,(select name from commcode where commcode.type=''C_job'' and commcode.val=cjob.job) job,describe,count,DECODE(cjob.sex,1,''男'',2,''女'',0,''不限'',''adsf'') sex,(select name from commcode where commcode.type=''C_age'' and commcode.val=cjob.age1) age1,(select name from commcode where commcode.type=''C_age'' and commcode.val=cjob.age2) age2,(select name from commcode where commcode.type=''C_education'' and commcode.val=cjob.education) education,DECODE(marry,0,''不限'',1,''已婚'',2,''未婚'') marry,(select name from commcode where commcode.type=''C_experience'' and commcode.val=cjob.experience) experIEnce,require, place,salary,treatment,valid,isvalid,leavedate from companyjob cjob where cjob.id=2