SQL 语句

select * from Job_Person where UserName='good'


select * from Job_Person where Flag='0' and Language2!=''

select * from Job_zhiyelist


select a.id,a.iname,
(case a.Diploma 
when '1' then '博士' when '2' then 'MBA' when '3' then '硕士' when '4' then '本科' when '5' then '大专' when '6'
 then '中专' when '7' then '中技' when '8' then '高中' when '9' then '初中' else a.diploma end) as Diploma,
(case a.JobYear
when '1' then '在读学生' when '2' then '应届毕业生' when '3' then '一年以内' when '4' then '一年以上' when '5'
 then '二年以上' when '6' then '三年以上' when '7' then '五年以上' when '8' then '十年以上' else a.JobYear end) as JobYear,
a.StudySpeciality,a.Hobby,a.Language2 ,b.ItemName from Job_person as a, Job_ZhiYeList  as b order by  a.id desc


select a.id,a.iname,
(case a.Diploma 
when '1' then '博士' when '2' then 'MBA' when '3' then '硕士' when '4' then '本科' when '5' then '大专' when '6'
 then '中专' when '7' then '中技' when '8' then '高中' when '9' then '初中' else a.diploma end) as Diploma,
(case a.JobYear
when '1' then '在读学生' when '2' then '应届毕业生' when '3' then '一年以内' when '4' then '一年以上' when '5'
 then '二年以上' when '6' then '三年以上' when '7' then '五年以上' when '8' then '十年以上' else a.JobYear end) as JobYear,
a.StudySpeciality,a.Hobby,(case a.language2 when a.language2 then b.ItemName else a.Language2 end)as Language2 ,b.ItemName 
from Job_person as a, Job_ZhiYeList  as b where a.Language2=b.ItemCode and (isnumeric(a.language2))=1  order by  a.id desc



select a.*,
(case a.language2 when a.language2 then b.ItemName else a.Language2 end)as Language2
 from job_zhiyelist as b,job_Person as a
where a.username like 'goo%' and (isnumeric(a.language2))=1 and (b.itemcode=a.language2)


select * from job_person where isnumeric(job_person.language2)=1