Select TOP 9 a.jobid,a.chusheng,a.chrname,a.dtappenddate,
a.zhuangye,a.yuexin,a.xueli,b.categoryid From [rencai]
a Join [category] b On
a.yuexin = b.categoryid
a.xueli = b.categoryid where a.iskill=1 order by jobid desc
a.yuexin
a.xueli两处需要输出b.categoryid的值
a.zhuangye,a.yuexin,a.xueli,b.categoryid From [rencai]
a Join [category] b On
a.yuexin = b.categoryid
a.xueli = b.categoryid where a.iskill=1 order by jobid desc
a.yuexin
a.xueli两处需要输出b.categoryid的值
a.zhuangye,a.yuexin,b.categoryid ,a.xueli,c.categoryid
From [rencai] a
Join [category] b On a.yuexin = b.categoryid
Join [category] c On a.xueli = c.categoryid
where a.iskill=1 order by jobid desc
Join [category] c On a.xueli = c.categoryid--加上这一段
a.zhuangye,a.yuexin,b.categoryid ,a.xueli,c.categoryid
From [rencai] a
Join [category] b On a.yuexin = b.categoryid
Join [category] c On a.xueli = c.categoryid
where a.iskill=1 order by jobid desc
Select TOP 9 a.jobid,a.chusheng,a.chrname,a.dtappenddate,
a.zhuangye,a.yuexin,b.categoryid ,a.xueli,c.categoryid,
月薪=b.种类名称字段,
学历=b.种类名称字段
From [rencai] a
Join [category] b On a.yuexin = b.categoryid
Join [category] c On a.xueli = c.categoryid
where a.iskill=1 order by jobid desc