做图书管理系统Sql语言用count计算图书借出数目，用左连接连接书表和数量。

sql语句：

sqlStr="select MainTable.bookid,MainTable.bookname,bookwriter,pulisher,publicationDate,category,amount,ISNULL(SubTable.SubNum,0) 
as amount2 from booktable as MainTable 
left join (select bookid,count(1) as SubNum from borrowrecords group by bookid)as SubTable
 on MainTable.bookid=SubTable.bookid";

booktable

 borrowrecords:

是通过查询解决的。