视图去重问题

Question

SELECT DISTINCT 
                      TOP (100) PERCENT dbo.BookInfo.BID, dbo.BookInfo.ISBN, dbo.BookInfo.BName, dbo.BookInfo.BPubDate, dbo.BookInfo.BPubNo, 
                      dbo.BookInfo.BRe, 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  还是去除不了重复。。不知道哪错了。。大家帮忙看下。

Answer 1

首先你的重复是什么样的重复??..
DISTINCT是去掉行完全一样的记录.例如:col1    col2    col3
1       2        3
1       2        4
1       2        5这样DISTINCT是不会去重复的.