select
M_SD.ID as ShoppingCartID
,P_P.ID as ProductID
,P_P.ProductName
,M_M.RealName
,B_C.ColorName
,B_S.Name as SizeName
,M_SD.Quantity
,P_PS.ProductImg
,M_SD.ProductDetailID
,M_SD.SellMemberID
from dbo.M_ShoppingCartDetail M_SD
left join dbo.P_ProductDetail P_PD
on M_SD.ProductDetailID=P_PD.ID
left join dbo.B_Color B_C
on P_PD.ColorID=B_C.ID
inner join dbo.B_Size B_S
on P_PD.SizeID=B_S.ID
inner join dbo.P_Product P_P
on P_PD.ProductID=P_P.ID
inner join dbo.P_ProductShowImg P_PS
on P_PS.ProductID=P_P.ID
inner join dbo.M_Member M_M
on M_M.ID=M_SD.SellMemberID数据是出来了,就是出现了重复的记录了,多个 ShoppingCartID了
求解?
lfte ,inner都试了,还是有重复的
而其他的并不相同?
select distinct
M_SD.ID as ShoppingCartID
,P_P.ID as ProductID
,P_P.ProductName
,M_M.RealName
,B_C.ColorName
,B_S.Name as SizeName
,M_SD.Quantity
,P_PS.ProductImg
,M_SD.ProductDetailID
,M_SD.SellMemberID
from dbo.M_ShoppingCartDetail M_SD
left join dbo.P_ProductDetail P_PD
on M_SD.ProductDetailID=P_PD.ID
left join dbo.B_Color B_C
on P_PD.ColorID=B_C.ID
inner join dbo.B_Size B_S
on P_PD.SizeID=B_S.ID
inner join dbo.P_Product P_P
on P_PD.ProductID=P_P.ID
inner join dbo.P_ProductShowImg P_PS
on P_PS.ProductID=P_P.ID
inner join dbo.M_Member M_M
on M_M.ID=M_SD.SellMemberID
distinct(M_SD.ID) as ShoppingCartID
,P_P.ID as ProductID
,P_P.ProductName
,M_M.RealName
,B_C.ColorName
,B_S.Name as SizeName
,M_SD.Quantity
,P_PS.ProductImg
,M_SD.ProductDetailID
,M_SD.SellMemberID
from dbo.M_ShoppingCartDetail M_SD
left join dbo.P_ProductDetail P_PD
on M_SD.ProductDetailID=P_PD.ID
left join dbo.B_Color B_C
on P_PD.ColorID=B_C.ID
inner join dbo.B_Size B_S
on P_PD.SizeID=B_S.ID
inner join dbo.P_Product P_P
on P_PD.ProductID=P_P.ID
inner join dbo.P_ProductShowImg P_PS
on P_PS.ProductID=P_P.ID
inner join dbo.M_Member M_M
on M_M.ID=M_SD.SellMemberIDdistinct()函数只能在查询语句的第一列,如果还不行,就只能写存储过程,把查出来的数据放入到临时表,添加一个临时表,给零时表设个主键,主键是不能重复的
但如下面的重复是正常的
部门1,姓名1
部门1,姓名2
部门1,姓名3一个部门有多个人,查询出现多条记录部门名称重复,是正常情况
如果要显示成以下格式
部门1,姓名1
姓名2
姓名3需对结果再作处理
这个我也知道
呵呵
drop table temp;
M_ShoppingCartDetail:M_SD.ProductDetailID是否1:N
重复的,说明你得数据有问题
添加条件处理或者Inner 结果集
where id=(select top 1 id from dbo.M_ShoppingCartDetail
where ShoppingCartID=a.ShoppingCartID order by id desc)