create table aaa_test as
select
edd.dealer_name daixiao_name,edat.after_parent_account
from
xueshenghui.em_daixiao_account_transaction@BIGTREE edat
left join xueshenghui.em_daixiao_dealer@BIGTREE edd on edat.daixiao_id = edd.id
select
edd.dealer_name daixiao_name,edat.after_parent_account
from
xueshenghui.em_daixiao_account_transaction@BIGTREE edat
left join xueshenghui.em_daixiao_dealer@BIGTREE edd on edat.daixiao_id = edd.id
where 1 = 1 and edat.created<=to_date('2014-04-20 23:59:59','yyyy-mm-dd hh24:mi:ss') order by edat.created
通过EXCEL导入外部数据,选中aaa_test表,就导出了