3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
怎么才行将数据较好的显示出来。。。
我想从下面六个表（d_leader_change,
d_new_expense,
d_new_operation,
d_new_sales,
d_oper_rival,
d_VPMN ）
中分别提取如下字段合一个表并按录入时间显示记录，这六个表中Cfgsm,Cdxsm,Clrsj(此字段为录入时间）三个字段为共有字段，请问怎么才能将数据显示出来。。。
SELECT d_new_expense.Cfgsm,
d_new_expense.Cdxsm,
d_new_expense.Czfxm,
d_new_expense.Cxxzc,
d_new_expense.Cylzc,
d_new_sales.Ctcmc,
d_new_sales.Czfbz,
d_new_sales.Czjbz,
d_VPMN.CVPMN,
d_VPMN.Csydw,
d_VPMN.Csyrs,
d_oper_rival.Cclcs,
d_leader_change.Cbtqk,
d_new_operation.Cywmc,
d_new_operation.Czfbz,
d_new_operation.Cmbrq
FROM d_leader_change,
d_new_expense,
d_new_operation,
d_new_sales,
d_oper_rival,
d_VPMN
...........
如果有些表这一天没有记录，对应字段记录为空，即显示效果是这样子的
Cfgsm Cdxsm Czfxm Cxxzc ...Cclcs Cbtqk Cyywmc Czfbz Cmbrq Clrsj
天宁 移动 标准 长途 ... 换人 优惠 持卡 跑龙套 2003-12-08
天宁 移动 左面 硬功 ... 中型 良好 潮流 2003-12-09
d_new_expense,
d_new_operation,
d_new_sales,
d_oper_rival,
d_VPMN ）
中分别提取如下字段合一个表并按录入时间显示记录，这六个表中Cfgsm,Cdxsm,Clrsj(此字段为录入时间）三个字段为共有字段，请问怎么才能将数据显示出来。。。
SELECT d_new_expense.Cfgsm,
d_new_expense.Cdxsm,
d_new_expense.Czfxm,
d_new_expense.Cxxzc,
d_new_expense.Cylzc,
d_new_sales.Ctcmc,
d_new_sales.Czfbz,
d_new_sales.Czjbz,
d_VPMN.CVPMN,
d_VPMN.Csydw,
d_VPMN.Csyrs,
d_oper_rival.Cclcs,
d_leader_change.Cbtqk,
d_new_operation.Cywmc,
d_new_operation.Czfbz,
d_new_operation.Cmbrq
FROM d_leader_change,
d_new_expense,
d_new_operation,
d_new_sales,
d_oper_rival,
d_VPMN
...........
如果有些表这一天没有记录，对应字段记录为空，即显示效果是这样子的
Cfgsm Cdxsm Czfxm Cxxzc ...Cclcs Cbtqk Cyywmc Czfbz Cmbrq Clrsj
天宁 移动 标准 长途 ... 换人 优惠 持卡 跑龙套 2003-12-08
天宁 移动 左面 硬功 ... 中型 良好 潮流 2003-12-09
...全文
请发表友善的回复…
发表回复
DaGod123 2003-12-09
用dist
uoche 2003-12-09
可能我没表达清楚。。。简单点说，就是上面六个表中的每条记录，在合成表中都只显示一次
例如在2003-12-09，a表只有一条记录是 1、aa aa1 aa2 aa3...2003-12-09
b表有两条记录是 1、bb bbl bb3 bb4...2003-12-09
2、cc cc2 cc3 cc4...2003-12-09
他们合成后效果如下
1、 aa aa1 aa2 aa3 bb bbl bb3 bb4...2003-12-09
2、 cc cc2 cc3 cc4...2003-12-09
例如在2003-12-09，a表只有一条记录是 1、aa aa1 aa2 aa3...2003-12-09
b表有两条记录是 1、bb bbl bb3 bb4...2003-12-09
2、cc cc2 cc3 cc4...2003-12-09
他们合成后效果如下
1、 aa aa1 aa2 aa3 bb bbl bb3 bb4...2003-12-09
2、 cc cc2 cc3 cc4...2003-12-09
shuiniu 2003-12-09
FROM d_leader_change a left join d_new_expense b
on a.Cfgsm = b.cfgsm and a.Cdxsm = b.cdxsm and a.Clrsj = b.clrsj
left join d_new_operation c
on a.Cfgsm = c.cfgsm and a.Cdxsm = c.cdxsm and a.Clrsj = c.clrsj
left join d_new_sales d
on a.Cfgsm = d.cfgsm and a.Cdxsm = d.cdxsm and a.Clrsj = d.clrsj
left join d_oper_rival e
on a.Cfgsm = e.cfgsm and a.Cdxsm = e.cdxsm and a.Clrsj = e.clrsj
left join d_VPMN f
on a.Cfgsm = f.cfgsm and a.Cdxsm = f.cdxsm and a.Clrsj = f.clrsj
...........
----------------------------------
????
on a.Cfgsm = b.cfgsm and a.Cdxsm = b.cdxsm and a.Clrsj = b.clrsj
left join d_new_operation c
on a.Cfgsm = c.cfgsm and a.Cdxsm = c.cdxsm and a.Clrsj = c.clrsj
left join d_new_sales d
on a.Cfgsm = d.cfgsm and a.Cdxsm = d.cdxsm and a.Clrsj = d.clrsj
left join d_oper_rival e
on a.Cfgsm = e.cfgsm and a.Cdxsm = e.cdxsm and a.Clrsj = e.clrsj
left join d_VPMN f
on a.Cfgsm = f.cfgsm and a.Cdxsm = f.cdxsm and a.Clrsj = f.clrsj
...........
----------------------------------
????