如何改成使用 SQL-92 语法

[yangkezhu]

SELECT GY_YGDM.YGXM,
V_MS_GHMX.YSDM,
V_MS_GHMX.KSDM,
COUNT(*) AS GHRC,
SUM(V_MS_GHMX.GHJE) AS GHJE,
SUM(V_MS_GHMX.ZLJE) AS ZLJE,
SUM(V_MS_GHMX.BLJE) AS BLJE,
SUM(V_MS_GHMX.ZJFY) AS ZJJE,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ
FROM V_MS_GHMX,
GY_YGDM,
MS_GHKS
WHERE ( V_MS_GHMX.KSDM *= MS_GHKS.KSDM ) and
( V_MS_GHMX.YSDM *= GY_YGDM.YGDM ) AND
( V_MS_GHMX.HZRQ >= 2004-11-16) and
( V_MS_GHMX.HZRQ <= 2004-11-20) and
( V_MS_GHMX.MZLB = 1)
group by V_MS_GHMX.YSDM,
GY_YGDM.YGXM,
V_MS_GHMX.KSDM,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ
如何把上面的语句改成使用 SQL-92 语法，望指教。

[xingfuniao]

SELECT GY_YGDM.YGXM,
V_MS_GHMX.YSDM,
V_MS_GHMX.KSDM,
COUNT(*) AS GHRC,
SUM(V_MS_GHMX.GHJE) AS GHJE,
SUM(V_MS_GHMX.ZLJE) AS ZLJE,
SUM(V_MS_GHMX.BLJE) AS BLJE,
SUM(V_MS_GHMX.ZJFY) AS ZJJE,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ
FROM V_MS_GHMX left join GY_YGDM on V_MS_GHMX.YSDM *= GY_YGDM.YGDM
left join MS_GHKS on V_MS_GHMX.KSDM *= MS_GHKS.KSDM
WHERE ( V_MS_GHMX.HZRQ >= 2004-11-16) and
( V_MS_GHMX.HZRQ <= 2004-11-20) and
( V_MS_GHMX.MZLB = 1)
group by V_MS_GHMX.YSDM,
GY_YGDM.YGXM,
V_MS_GHMX.KSDM,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ

[yangkezhu]

运行不对啊，提示：在包含已联接的表的查询中，不能指定外联接操作符。错误提示在这一句：left join MS_GHKS on V_MS_GHMX.KSDM *= MS_GHKS.KSDM

[xingfuniao]

刚才改的时候忘记把那个*去掉了，去掉*就可以，如下，在试试
SELECT GY_YGDM.YGXM,
V_MS_GHMX.YSDM,
V_MS_GHMX.KSDM,
COUNT(*) AS GHRC,
SUM(V_MS_GHMX.GHJE) AS GHJE,
SUM(V_MS_GHMX.ZLJE) AS ZLJE,
SUM(V_MS_GHMX.BLJE) AS BLJE,
SUM(V_MS_GHMX.ZJFY) AS ZJJE,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ
FROM V_MS_GHMX left join GY_YGDM on V_MS_GHMX.YSDM = GY_YGDM.YGDM
left join MS_GHKS on V_MS_GHMX.KSDM = MS_GHKS.KSDM
WHERE ( V_MS_GHMX.HZRQ >= 2004-11-16) and
( V_MS_GHMX.HZRQ <= 2004-11-20) and
( V_MS_GHMX.MZLB = 1)
group by V_MS_GHMX.YSDM,
GY_YGDM.YGXM,
V_MS_GHMX.KSDM,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ

[xingfuniao]

*= 代表左连接的意思，sql92不支持该T-Sql

[zhang_yzy]

SELECT GY_YGDM.YGXM,
V_MS_GHMX.YSDM,
V_MS_GHMX.KSDM,
COUNT(*) AS GHRC,
SUM(V_MS_GHMX.GHJE) AS GHJE,
SUM(V_MS_GHMX.ZLJE) AS ZLJE,
SUM(V_MS_GHMX.BLJE) AS BLJE,
SUM(V_MS_GHMX.ZJFY) AS ZJJE,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ
FROM V_MS_GHMX LEFT JOIN MS_GHKS ON V_MS_GHMX.KSDM=MS_GHKS.DSDM
LEFT JOIN GY_YGDM ON V_MS_GHMX.YSDM=GY_YGDM.YGDM
WHERE ( V_MS_GHMX.HZRQ >= 2004-11-16) and
( V_MS_GHMX.HZRQ <= 2004-11-20) and
( V_MS_GHMX.MZLB = 1)
group by V_MS_GHMX.YSDM,
GY_YGDM.YGXM,
V_MS_GHMX.KSDM,
MS_GHKS.GHLB,
MS_GHKS.ZJMZ