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命令未正确结束
请大家指点···