两表相连去除重复数据
时间:2011-06-08 来源:裴鹏
select p.product_id,max(i.ImagesPath) ImagesPath from teapp as p,Base_Images as i
where p.Product_id=i.Product_Id group by p.product_id
相关阅读 更多 +
时间:2011-06-08 来源:裴鹏
select p.product_id,max(i.ImagesPath) ImagesPath from teapp as p,Base_Images as i
where p.Product_id=i.Product_Id group by p.product_id