Select
P.Productdh,P.text,A.PRICE
from
Product P,(Select Productdh,MIN(thprice) as PRICE from Allprice) A
Where
P.Productdh=A.Productdh省掉了些字段...
P.Productdh,P.text,A.PRICE
from
Product P,(Select Productdh,MIN(thprice) as PRICE from Allprice) A
Where
P.Productdh=A.Productdh省掉了些字段...
用sql2000 ,把相关字段,用鼠标拉,限制条件在下面简单写
http://expert.csdn.net/Expert/topic/2064/2064521.xml?temp=.9391291
P.Productdh,P.text,A.PRICE
from
Product P,(Select Productdh,MIN(thprice) as minPRICE from Allprice Group by Productdh) A
Where
P.Productdh=A.Productdh
P.Productdh,P.text,A.minPRICE
from
Product P,(Select Productdh,MIN(thprice) as minPRICE from Allprice Group by Productdh) A
Where
P.Productdh=A.Productdh
from Product AS P LEFT OUOTER JOIN (Select Productdh,MIN(thprice) as minPRICE from Allprice Group by Productdh) AS A ON P.Productdh=A.Productdh
就不会有重复记录出现
恭喜你解决了问题