INSERT T_NZLHIS(UPLDDTE,NZLID,NZLNAME,NZLCNT,NZLERR,NZLPER,NZLNPC,NZLRJP,NZLFMDF,NZLMDF,NZLMTIME,NZLMID,LASTCNT,LASTERR,RESULTAVG)
SELECT a.*,0,0,d.NZLCNT as LASTCNT,d.NZLERR as LASTERR,
(CASE a.NZLCNT-d.NZLCNT
WHEN 0 THEN d.RESULTAVE ELSE
(a.NZLERR-d.NZLERR)/(a.NZLCNT-d.NZLCNT) END) as RESULTAVG
FROM T_NZLBLN a,
(select NZLID,NZLCNT,NZLERR,RESULTAVG from T_NZLHIS b
inner join
(select max(id) as id
from T_NZLHIS
group by NZLID) c on b.id=c.id) d
where a.NZLID>'' and a.NZLID=d.NZLID;
mysql问题:字段名前面的a. b. c. d.是什么意思,谁能看懂这段代码
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
2条回答 默认 最新
- threenewbee 2016-06-22 07:32关注
表或者子查询的别名 T_NZLBLN a,a就是表T_NZLBLN (select max(id) as id from T_NZLHIS group by NZLID) c c 就是前面的那个子查询 别的类似
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报