INNER JOIN两个表获取错误SQL语句未正确结束

 收藏

I have two table which I want to select Name from t2. The situation is following. I have t1 Policy which containt EmployeeID And table t2 which containt Name Now I want to select which Employee release policy. So in t1(Policy- AUTO.POL) I have column: SIFRA_RAD and t2(Employee-AUTO.SIFRAD) I have colum: SIFRA_R, Ime

我尝试这样的事情:

select auto.pol.sifra_rad, auto.sifrad.ime
from auto.sifrad 
inner join auto.pol on  auto.sifrad.ime = auto.pol.sifra_rad;

之后,我得到错误

ORA-00933: SQL command not properly ended

我不知道这是怎么了。有什么建议吗?

回复
  • Linda 回复

    问题来自查询,我们已解决

    select p.sifra_rad, s.ime from auto.sifrad s, auto.pol p where s.ime = p.sifra_rad