借还书表SQL语句求教
四个表：
Lend(Lid,LendDate),
LendDetail(Lid,bookid,Lendno),
Return(Rid,Lid,ReturnDate),
ReturnDetail(Rid,bookid,Returnedno)
要求得出以下结果：
Lend.Lid| Lend.LendDate| LendDetail.bookid|LendDetail.Lendno|Sum(ReturnDetail.Returnedno)
1 2005-6-1 11 5 1
1
[295 byte] By [
msdn] at [2007-10-1 16:51:02]
# 1 Re: 借还书表SQL语句求教
楼主试试
Select
A.Lid,
A.LendDate,
B.bookid,
B.LendDetail.Lendno,
C.SUMReturnedno
from Lend A
Left Join LendDetail B On A.Lid=B.Lid
Left Join (Select D.Lid,SUM(E.Returnedno) As SUMReturnedno from [Return] D Left Join ReturnDetail E On D.Rid=E.Rid Group By D.Lid) C
On A.Lid=C.Lid
paoluo at 2005-6-29 16:51:41 >
