bookloan.qpr

来自「用VFP实现的图书馆数据库管理」· QPR 代码 · 共 9 行

SELECT Loan.stuid AS 学号, Student.name AS 姓名, Book.bookno AS 书号,;
  Book.bookname AS 书名,;
  MONTH(DATE())*30+DAY(DATE())-MONTH(Loan.loandate) *30 + DAY(Loan.loandate)-10 as 逾期天数;
 FROM  library!book INNER JOIN library!loan;
    INNER JOIN library!student ;
   ON  Student.stuid = Loan.stuid ;
   ON  Book.bookno = Loan.bookno;
 WHERE Book.isloan = .F.