
复制--借阅视图 create view V_Borrow as select 图书编号=books.bid,实现r视 图书名=books.bname, 读者编号=readers.rid,读者姓名=readers.rname, 借阅日期=borrows.borrowdate,归还日期=borrows.returndate from books inner join borrows on books.bid=borrows.bid inner join readers on readers.rid=borrows.rid --借阅视图 create view V_Borrow as select 图书编号=books.bid, 图书名=books.bname, 读者编号=readers.rid,读者姓名=readers.rname, 借阅日期=borrows.borrowdate,归还日期=borrows.returndate from books inner join borrows on books.bid=borrows.bid inner join readers on readers.rid=borrows.rid 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.


相关文章



精彩导读

热门资讯
关注我们
