select a.prono,a.pclass1no,a.pclass2no,a.name,a.text1,a.text2,a.text3,a.spe,a.price,a.pic1,a.sort,a.times,a.status,a.pic2,a.pic3,b.name,b.name_e,a.fileclass,a.filename,a.file,b.pic1 from pro a,pclass1 b where a.prono='983' and a.pclass2no=b.pclass1no and a.status='1'