你好，我正在建立一个查询1.在芝加哥的咨询公司找工作

Question

我在SQL中有以下表:

• Company (compid, compname, comptype)
• 工作(职位，职位名称，低工资，高工资，地点，价格*)
• Skills (skill, skillname)
• 工作技能(jobid, skidd, expertisenneeded)
• 申请人(姓名、年龄、学历、期望薪资)
• AppSkills (appid, skill, expertise)
• 应用(投标、申请、申请日期、决定日期、结果)

当我在Oracle developer中运行这段代码:

select 
j.jobid, j.jobtitle
from 
Job as j
inner join 
Company as c on j.compid = c.compid
where 
c.comtype = 'consulting'
and j.location = 'Chicago';

然后我得到这个错误:

ORA-00933: SQL命令未正确结束

Answer 1

在Oracle中，表别名不允许AS关键字:

select 
j.jobid, j.jobtitle
from 
Job as j                                 --> remove AS here ...
inner join 
Company as c on j.compid = c.compid      --> ... and here
where 
c.comtype = 'consulting'
and j.location = 'Chicago';