求mysql里面的两表联查分页语句
create table Book (
BID int identity,
BSID int null,
BName nvarchar(200) not null,
BAuthor nvarchar(200) not null,
BISBN nvarchar(50) not null,
BTOC ntext null,
BComment ntext null,
BPic nvarchar(100) null,
BPrice numeric(8,2) not null,
BCount int not null,
BDate datetime not null,
BSaleCount int null,
constraint PK_BOOK primary key (BID)
)
create table BSCategory (
BSID int identity,
BLID int null,
BLName varchar(30) not null,
constraint PK_BSCATEGORY primary key (BSID)
)
这两个表中的bsid是主外键关系 我的要求是要分页,请各位大神指点指点哈,具体是什么样的请告知!!!