select *
,jcat.catename as j_catename
,ecat.catename as e_catename
from queslist
left outer join jbn_job as jjob on we_job = jobid
left outer join jbn_cate as jcat on we_cat = jcat.cateid
left outer join category as ecat on indusclas = ecat.cateid
where quesnum =
and (openflag = 'Y' or userattrib = 'J')