CREATE PROCEDURE Pr_GetBookByCategory
(
@CategoryID int
)
ASSELECT
Book.*,Category.Desn AS CategoryDesn,
Picture.Url
FROM
Book
INNER JOIN
Category
ON
Category.CategoryID = Book.CategoryID
LEFT JOIN
Picture
ON
Book.BookID = Picture.BookID AND IsShow = 1WHERE
Book.CategoryID = @CategoryIDORDER BY
PublishDate DESCGO
(
@CategoryID int
)
ASSELECT
Book.*,Category.Desn AS CategoryDesn,
Picture.Url
FROM
Book
INNER JOIN
Category
ON
Category.CategoryID = Book.CategoryID
LEFT JOIN
Picture
ON
Book.BookID = Picture.BookID AND IsShow = 1WHERE
Book.CategoryID = @CategoryIDORDER BY
PublishDate DESCGO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货