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命令未正确结束请大家指点···
给你排列了下,再试下: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 '%计算机%';
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 '%计算机%';
顶,真仔细建议写sql语句的时候还是用专门的工具,有关键字高亮显示
可以避免这样的低级错误
--关键字的问题
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 '%计算机%';