sql语句如下select count(BooksID) num,u.usersId id
from
books bb right join booklists bl right join cyberdigests c right join users u on c.usersId=u.usersId on bb.BooklistsID=bl.BooklistsID on bl.CyberDigestsID=c.CyberDigestsID
group by u.usersIdbooks 表内的字段
BooksID
BooklistsID
BooksLocation
BooksName booklists 表内的字段
BooklistsID
CyberDigestsID
BooklistsName
BooklistsDescribe
BooksAmount
cyberdigests 表内的字段
CyberDigestsID
usersId
CyberDigestsName
users 表被的字段
usersId
usersName
usersPwd
usersType
from
books bb right join booklists bl right join cyberdigests c right join users u on c.usersId=u.usersId on bb.BooklistsID=bl.BooklistsID on bl.CyberDigestsID=c.CyberDigestsID
group by u.usersIdbooks 表内的字段
BooksID
BooklistsID
BooksLocation
BooksName booklists 表内的字段
BooklistsID
CyberDigestsID
BooklistsName
BooklistsDescribe
BooksAmount
cyberdigests 表内的字段
CyberDigestsID
usersId
CyberDigestsName
users 表被的字段
usersId
usersName
usersPwd
usersType
select count(BooksID) num,u.usersId id
from
books bb
right join booklists bl
on bb.BooklistsID=bl.BooklistsID
right join cyberdigests c
on bb.xx = c.xx
right join users u
on c.xx=bb.xx group by u.usersId