select m.* from(select rownum rown,b.* from wl_book_books b inner join wl_book_publish p on b.publishid = p.id where 1=1 and rownum<=5)m where rown>=1 红色的代码报未定义的错误,怎么按照这样的条件来查询呢?谢谢!
複製進去應該可以 select m.* from(select rownum rown,b.* from wl_book_books b inner join wl_book_publish p on b.publishid = p.id where 1=1 and rownum<=5) m where rown>=1
select m.* from(select rownum rown,b.*,p.name from wl_book_books b inner join wl_book_publish p on b.publishid = p.id where 1=1 and rownum<=5) m where rown>=1其实是想要查询两个表的数据,因为都有ID识别不了,就报未定义的错误。已经解决的了!谢谢!
select * from .....
select m.* from(select rownum rown,b.* from wl_book_books b inner join wl_book_publish p on b.publishid = p.id where 1=1 and rownum<=5) m where rown>=1