视图去重问题
SELECT DISTINCT
TOP (100) PERCENT dbo.BookInfo.BID, dbo.BookInfo.ISBN, dbo.BookInfo.BName, dbo.BookInfo.BPubDate, dbo.BookInfo.BPubNo,
dbo.BookInfo.BRemark, dbo.BookInfo.BImage, dbo.BookInfo.BUpTime, dbo.BookPriceInfo.OriginalPrice, dbo.BookPriceInfo.FinalPrice,
dbo.BookPriceInfo.CostSaving, dbo.BStateInfo.StateName, dbo.BookGradeInfo.BookGrade, dbo.BTypeInfo.TName, dbo.PublisherInfo.PubName,
dbo.AuthorInfo.AName, dbo.AuthorInfo.ATranName, dbo.BTypeInfo.TNumber
FROM dbo.AreaDetailInfo INNER JOIN
dbo.AuthorInfo ON dbo.AreaDetailInfo.AID = dbo.AuthorInfo.AID CROSS JOIN
dbo.PublisherInfo INNER JOIN
dbo.BookPriceInfo ON dbo.PublisherInfo.PID = dbo.BookPriceInfo.PID INNER JOIN
dbo.BookInfo ON dbo.PublisherInfo.PID = dbo.BookInfo.BPID AND dbo.BookPriceInfo.PID = dbo.BookInfo.PID INNER JOIN
dbo.BookGradeInfo ON dbo.BookInfo.BGradeID = dbo.BookGradeInfo.BGID INNER JOIN
dbo.BTypeInfo ON dbo.BookInfo.TID = dbo.BTypeInfo.TID INNER JOIN
dbo.BStateInfo ON dbo.BookInfo.SID = dbo.BStateInfo.SID
用了DISTINCT 还是去除不了重复。。不知道哪错了。。大家帮忙看下。