标题: load请教 [打印本页] 作者: tolerances 时间: 2007-06-27 10:03 标题: load请教 unload to 1111.txt
select mxbz,kh_kh,je,polno,kh_mc,jylx,by1,by2,by3,by4
from XXXXXX
where time = today
我想在这个1111.txt 文件的第一行加上一条汇总数据所写sql如下
unload to 11111.txt
select hzbz,gsdm,ssjph,sfbz,zjs,zje,by1,by2,'',''
from XXX_hz
where time = today
union
select mxbz,kh_kh,je,polno,kh_mc,jylx,by1,by2,by3,by4
from XXXXXX
where time = today