SELECT
dbo.Product.Type_Name,
dbo.Product.Title,
dbo.Product.IncludeSmallPic,
dbo.Product.IncludePic,
tt.Type_Name AS Cata_Name,
tt.Type_Path
FROM dbo.Product INNER JOIN
(SELECT
Type_ID,
Type_Name,
Type_Path,
Type_Content
FROM dbo.Type_Pro WHERE (Big_ID = 25)) AS tt
ON dbo.Product.Type_Name = tt.Type_ID
WHERE (dbo.Product.BigClassName = 25)
以下是我查询出来的界面
我要的结果是:(界面上字段为Type_Name的[138.139.140])
每个类别名下只显示相应的(title)一条记录.不要title全显示完.每个分类取一条相对应类别的产品,不要显示全部产品