三表链接查询的问题，报ORA-00933错误

[Arousal_Fish]

select ROWNUM r,b.*,p.*,c.*
from  LIB_BOOKS b jion LIB_PUBLISHES p on ( b.PUB_ID=P.PUB_ID )
                  jion LIB_CATEGORIES c on ( c.CATE_ID=b.CATE_ID )
where b.BOOK_NAME like '%java%' and b.BOOK_WRITER like '%李%' 
  and p.PUB_NAME like '%工业%' and c.CATE_NAME like '%计算机%';

报错是，第二行，ORA-00933：SQL命令未正确结束

请大家指点···

[范佩西_11]

没看出什么错误
给你排列了下，再试下：

select ROWNUM r, b.*, p.*, c.*
  from LIB_BOOKS b jion LIB_PUBLISHES p on (b.PUB_ID = P.PUB_ID) jion
 LIB_CATEGORIES c
 on(c.CATE_ID = b.CATE_ID)
 where b.BOOK_NAME like '%java%'
   and b.BOOK_WRITER like '%李%'
   and p.PUB_NAME like '%工业%'
   and c.CATE_NAME like '%计算机%';

[范佩西_11]

倒看出来了，jion----->join

select ROWNUM r, b.*, p.*, c.*
  from LIB_BOOKS b
  join LIB_PUBLISHES p on (b.PUB_ID = P.PUB_ID)
  join LIB_CATEGORIES c on (c.CATE_ID = b.CATE_ID)
 where b.BOOK_NAME like '%java%'
   and b.BOOK_WRITER like '%李%'
   and p.PUB_NAME like '%工业%'
   and c.CATE_NAME like '%计算机%';

[conna]

[Quote=引用 2 楼 linzhangs 的回复:]
倒看出来了，jion----->join

SQL codeselect ROWNUM r, b.*, p.*, c.*
from LIB_BOOKS b
join LIB_PUBLISHES p on (b.PUB_ID = P.PUB_ID)
join LIB_CATEGORIES c on (c.CATE_ID = b.CATE_ID)
where b.BOOK_NAME like '%java%'
and b.BOOK_WRITER like '%李%'
and p.PUB_NAME like '%工业%'
and c.CATE_NAME like '%计算机%';
[/Quote]

顶，真仔细

建议写sql语句的时候还是用专门的工具，有关键字高亮显示
可以避免这样的低级错误

[oraclelogan]

jion-->join
--关键字的问题
select ROWNUM r,b.*,p.*,c.*
from  LIB_BOOKS b jion LIB_PUBLISHES p on ( b.PUB_ID=P.PUB_ID )
                  jion LIB_CATEGORIES c on ( c.CATE_ID=b.CATE_ID )
where b.BOOK_NAME like '%java%' and b.BOOK_WRITER like '%李%' 
  and p.PUB_NAME like '%工业%' and c.CATE_NAME like '%计算机%';

[ruihuahan]

呵呵。够仔细。

[chensi05]

这样低级的错误完全工具可以避免的

[fuyou001]

各位真细心