SELECT
HEAD.PNO PNO,
SUM(MEI.KOSI) SI,
SUM(MEI.AMOUNT) AMOUNT
FROM
AHEAD HEAD
LEFT JOIN
BMEI MEI
ON
HEAD.PAYYOTENO = MEI.PAYYOTENO
LEFT JOIN
MSMASTER MMASTER
ON
MEI.CODE = MMASTER.KEY2
AND MMASTER.KBN = 'AA'
AND MMASTER.EY1 = 'NAME'
WHERE
HEAD.COMPANYID = 'T0'
AND HEAD.PAYDAY = '20070331'
AND HEAD.VALIDSTATUS = '0'
GROUP BY
PAYNO如上面的SQL,为什么这样写就执行不过,但把‘PAYNO’换成‘HEAD.PNO’就可以执行呢?
HEAD.PNO PNO,
SUM(MEI.KOSI) SI,
SUM(MEI.AMOUNT) AMOUNT
FROM
AHEAD HEAD
LEFT JOIN
BMEI MEI
ON
HEAD.PAYYOTENO = MEI.PAYYOTENO
LEFT JOIN
MSMASTER MMASTER
ON
MEI.CODE = MMASTER.KEY2
AND MMASTER.KBN = 'AA'
AND MMASTER.EY1 = 'NAME'
WHERE
HEAD.COMPANYID = 'T0'
AND HEAD.PAYDAY = '20070331'
AND HEAD.VALIDSTATUS = '0'
GROUP BY
PAYNO如上面的SQL,为什么这样写就执行不过,但把‘PAYNO’换成‘HEAD.PNO’就可以执行呢?
group by 就不可能用别名。
除非嵌套一层sql