SELECT
PLT_MST.PLANT
,PLT_MST.PLTNM AS PLANTNM
,MAX(HGK_MST.YUKDT) AS YUKDT
,MAX(HGK_MST.LOSDT) AS LOSDT
FROM
PLT_MST PLT
JOIN HGK_MST HGK
ON PLT.PLANT = HGK.PLANT
WHERE
HGK.CSTTP='MSG'
GROUP BY
PLT_MST.PLANT
PLT_MST.PLANT
,PLT_MST.PLTNM AS PLANTNM
,MAX(HGK_MST.YUKDT) AS YUKDT
,MAX(HGK_MST.LOSDT) AS LOSDT
FROM
PLT_MST PLT
JOIN HGK_MST HGK
ON PLT.PLANT = HGK.PLANT
WHERE
HGK.CSTTP='MSG'
GROUP BY
PLT_MST.PLANT
SELECT
PLT.PLANT
,PLT.PLTNM AS PLANTNM
,MAX(HGK_MST.YUKDT) AS YUKDT
,MAX(HGK_MST.LOSDT) AS LOSDT
FROM
PLT_MST PLT
JOIN HGK_MST HGK
ON PLT.PLANT = HGK.PLANT
WHERE
HGK.CSTTP='MSG'
GROUP BY
PLT_MST.PLANT
SELECT
PLT.PLANT
,PLT.PLTNM AS PLANTNM
,MAX(HGK.YUKDT) AS YUKDT
,MAX(HGK.LOSDT) AS LOSDT
FROM
PLT_MST PLT
JOIN HGK_MST HGK
ON PLT.PLANT = HGK.PLANT
WHERE
HGK.CSTTP='MSG'
GROUP BY
PLT.PLANT
(GROUP by的字段,需要是Select后面,除去SUM后的字段)