将查询内容插入到表中

insert overwrite table eleven3

select count(*) from (select a.xf_id,a.je-b.je as aaa

from eleven1 a inner join eleven2 b

  on a.xf_id=b.gf_id) as form1

where aaa>0;

 

posted @ 2021-10-03 23:08  xjspyx  阅读(40)  评论(0编辑  收藏  举报