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
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
转载于:https://www.cnblogs.com/peipeng0622/archive/2011/06/08/2075477.html