SELECT     dbo.CM_Book.BookID, dbo.CM_BookPageDetail.Title, dbo.CM_BookPageDetail.[Content], dbo.CM_BookPageDetail.Memo, dbo.CM_BookPage.PageID, 
                      dbo.CM_BookCategory.CategoryID, dbo.CM_Book.BookName, AuthorInfo.AuthorID, AuthorInfo.AuthorName
FROM         dbo.CM_Book INNER JOIN
                      dbo.CM_BookCategory ON dbo.CM_Book.CategoryID = dbo.CM_BookCategory.CategoryID INNER JOIN
                      dbo.CM_BookPage ON dbo.CM_Book.BookID = dbo.CM_BookPage.BookID INNER JOIN
                      dbo.CM_BookPageDetail ON dbo.CM_BookPage.PageID = dbo.CM_BookPageDetail.BookPageId LEFT OUTER JOIN
                          (SELECT     dbo.CM_BookAuthorRelation.BookID, dbo.CM_BookAuthor.AuthorID, dbo.CM_BookAuthor.AuthorName
                            FROM          dbo.CM_BookAuthorRelation INNER JOIN
                                                   dbo.CM_BookAuthor ON dbo.CM_BookAuthorRelation.AuthorID = dbo.CM_BookAuthor.AuthorID) AS AuthorInfo ON 
                      dbo.CM_Book.BookID = AuthorInfo.BookID