视图语句.txt

图书馆借书查询管理系统向用户提供的服务将在传统的“采->编->借->查”的基础上

Create view  readinfo as 
Select leid as leid , count(*) as bsum ,sum(fakuan) as fajin from lendinfo group by leid