帮我看看看个SQL那里错了
功能主要是得到product 不重复记录
select childid ,id from product where ProductDown=0 and exists ( select ProductID from ProInfo where UserID='280900' and ProInfoType='factory' and product.id=ProInfo.ProductID ) and (id in(Select max(id) FROM product where group by childid))