7计算方法.sql

1.写出建立BORROW表的SQL语句

SELECT DISTINCT X.CNO FROM BORROW AS X, BORROW AS Y  
   WHERE  X.CNO=Y.CNO AND X.BNO IN
     (SELECT BORROW.BNO FROM BOOKS,BORROW
      WHERE BOOKS.BNO=BORROW.BNO AND BNAME='计算方法')AND Y.BNO NOT IN
     (SELECT BORROW.BNO FROM BOOKS,BORROW
      WHERE BOOKS.BNO=BORROW.BNO AND BNAME='计算方法习题集')
 ORDER BY X.CNO DESC