这个知道,但是表WT_QGQYDM定义了三个别名b,d,e,W_QNAME这一列也定义了三个别名 d.W_QNAME AS [省], e.W_QNAME AS [地市], b.W_QNAME AS [县](要在程序中引用的),我怀疑是这三列的问题,情况如下: SELECT a.Y_YID AS "企业序号",Y_QYMC AS "企业名称", d.W_QNAME AS "省", f.Y_HDZZL as "核定载重量"from YT_YSQY a,WT_QGQYDM b,WT_XTCYXXSM c,WT_QGQYDM d, WT_QGQYDM e,YT_CLXX f where b.W_QID=a.Y_DSXBM and c.W_XCSZ=Y_QYLSDM and c.W_XCSLX='企业类型' 这样可以在编译通过,但是再多加一列e.W_QNAME AS "地市",就报错说“未找到预期from关键字”,怎么回事?
d.W_QNAME AS [省],
e.W_QNAME AS [地市],
b.W_QNAME AS [县](要在程序中引用的),我怀疑是这三列的问题,情况如下:
SELECT a.Y_YID AS "企业序号",Y_QYMC AS "企业名称",
d.W_QNAME AS "省",
f.Y_HDZZL as "核定载重量"from YT_YSQY a,WT_QGQYDM b,WT_XTCYXXSM c,WT_QGQYDM d,
WT_QGQYDM e,YT_CLXX f
where b.W_QID=a.Y_DSXBM and
c.W_XCSZ=Y_QYLSDM and c.W_XCSLX='企业类型'
这样可以在编译通过,但是再多加一列e.W_QNAME AS "地市",就报错说“未找到预期from关键字”,怎么回事?