bookloan.qpr

用VFP实现的图书馆数据库管理

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.