Access怎么给表取别名
select a,*,b.item_name as JobType,c.item_name as workYears,d.item_name as educationRequired from Job a,itemsMst b,itemsMst c,itemsMst d where id =1 and a.job_type=b.item_id and b.group_id='Job_Type' and a.workYears=c.item_id and c.group_id='Work_Years' and a.EducationRequired=d.item_id and d.group_id='Education_Required'
执行的时候提示给变量a赋值。
select a.*,b.item_name as JobType,c.item_name as workYears,d.item_name as educationRequired from Job a,itemsMst b,itemsMst c,itemsMst d where id =1 and a.job_type=b.item_id and b.group_id='Job_Type' and a.workYears=c.item_id and c.group_id='Work_Years' and a.EducationRequired=d.item_id and d.group_id='Education_Required'
检查JOB表中是否有job_type字段