写个sql语句

显示全部楼层 · 2007-4-4 21:49:38

BOOK_ID有相同的字段？

千问 · 2007-4-4 21:49:38

库存字段,你没有,你自己按照下面的自己来加吧SELECT BOOK_NAME AS '书名',PUBLISH AS '出版社',BOOK_TYPE AS '类型',STATUS AS '可借'FROM BOOK WHERE status=true;

千问 · 2007-4-4 21:49:38

不对啊，你的的表是不是没给全啊？那你的“库存”从哪个表里差呢？

千问 · 2007-4-4 21:49:38

SELECT BOOK_NAME AS '书名',PUBLISH AS '出版社',BOOK_TYPE AS '类型',(SELECT COUNT(BOOK_ID)FROM BOOK WHERE BOOK_NAME = BOOK_NAME AND PUBLISH = PUBLISH AND ISBN = ISBN AND BOOK_TYPE = BOOK_TYPE) AS '库存',(SELECT COUNT(BOOK_ID)FROM BOOK WHERE BOOK_NAME = BOOK_NAME AND PUBLISH = PUBLISH AND ISBN = ISBN AND BOOK_TYPE = BOOK_TYPE AND STATUS='F') AS '可借' FROM BOOK这样你试试!!!