SELECT ls as 流水, yswx as 验收外协, zxqk as 执行情况, dmbm as 店面编码, dmmc as 店面名称, szfq as 所在分区, szsf as 所在省份, sscs as 所属城市, csjb as 城市级别, dmdz as 店面地址, dmxt as 店面形态,lxdh as 联系电话,[FD/VD], mddmlx as 名单店面类型 ,ysdlx as 验收单类型,cjsmc as 承建商名称,ypfj as 一票否决合计 ,hjdf as 合计得分, ysjg as 验收结果,ycysbz as 一次验收备注 from FD
UNION ALL
select ls, yswx, zxqk, dmbm, dmmc, szfq, szsf, sscs, csjb, dmdz, dmxt,lxdh,[FD/VD], mddmlx ,ysdlx,cjsmc,ypfj ,hjdf, ysjg ,ycysbz from VD
UNION ALL
select ls, yswx, zxqk, dmbm, dmmc, szfq, szsf, sscs, csjb, dmdz, dmxt,lxdh,[FD/VD], mddmlx ,ysdlx,cjsmc,ypfj ,hjdf, ysjg ,ycysbz from DB
UNION ALL
select ls, yswx, zxqk, dmbm, dmmc, szfq, szsf, sscs, csjb, dmdz, dmxt,lxdh,[FD/VD], mddmlx ,ysdlx,cjsmc,ypfj ,hjdf, ysjg ,ycysbz from PL
UNION ALL
select ls, yswx, zxqk, dmbm, dmmc, szfq, szsf, sscs, csjb, dmdz, dmxt,lxdh,[FD/VD], mddmlx ,ysdlx,cjsmc,ypfj ,hjdf, ysjg ,ycysbz from XY; 作者: ui 时间: 2011-1-1 16:33
参数对话框可能是有些字段或 条件没有作者: sinotrust 时间: 2011-1-1 21:27
谢谢大侠，你说的很对，我把出现参数对话框的那些字段重新的挨个对了一次，发现是有些地方的名字叫的不一样，改完之后就正确了。