表1
ProID ProName
1 a
2 b表2
ProID ProArea ProPric
1 BJ 10
1 SH 8
1 GZ 2
2 BJ 1
2 GZ 4我想得到每个产品的最低价格和最低价格所在地区以及产品信息:ID Name Area Pric
谢谢
ProID ProName
1 a
2 b表2
ProID ProArea ProPric
1 BJ 10
1 SH 8
1 GZ 2
2 BJ 1
2 GZ 4我想得到每个产品的最低价格和最低价格所在地区以及产品信息:ID Name Area Pric
谢谢
a.*,b.ProArea,b.ProPric
FROM
表1 a,表2 b
WHERE
a.ProID=b.ProID
AND
NOT EXISTS(SELECT 1 FROM 表2 WHERE ProID=a.ProID AND ProPric<b.ProPric)
ProID ProName
1 a
2 b 表2
ProID ProArea ProPric
1 BJ 10
1 SH 8
1 GZ 2
2 BJ 1
2 GZ 4 --------------------
select a.* ,b.ProArea, b.ProPric
from t1 a
left join
(select ProID,min(ProPric) from t2 group by ProID)b
on a.ProID=b.ProID