学步园

SELECT     ROW_NUMBER() OVER (ORDER BY dbo.tbMagazine.Magazine_ID DESC, dbo.tbArticle.Article_PageNum) AS RowID, dbo.tbMagazine.Magazine_ID,
dbo.tbMagazine.Magazine_Num, dbo.tbMagazine.Magazine_Date, dbo.tbMagazine.Magazine_Cover, dbo.tbArticle.Article_ID, dbo.tbArticle.Article_Title,
dbo.tbArticle.Article_Score, dbo.tbArticle.Article_Author, dbo.tbArticle.Article_PageNum, dbo.tbArticle.Article_Content
FROM         dbo.tbMagazine INNER JOIN
                      dbo.tbArticle ON dbo.tbMagazine.Magazine_ID = dbo.tbArticle.Magazine_ID