ALTER TABLE t_bcp_cash_fee_detail ADD INDEX IDX_CASH_FEE_DETAIL_RELATION(RELATION_ID);
解决方案 »
- 错误调查:table is full,cannot find a free slot for an undo log
- INSERT 数据后数据表没有及时刷新,怎么更新?
- sql需要优化 改or 为union sql
- Rowid_Mysql 环境取数,通过什么方式缔造一个rowid之类的东西呢?
- 蔡鸟请教关于Postgres数据导入的问题,急~~~
- 高手帮助phpmyadmin配置问题
- 在WIN2000 server中安装了mysql,想要卸载它,但在卸载它之后,发现服务中还有mysql项。
- 新手求助!在线等!昨天刚装上MySql,试了一下可以用,今天打开的时候,输入密码后就闪退了~
- 如何把表中的数据复制到另一台服务器上?
- php连接mysql的问题麻烦大家给看看--
- 求助一条SQL的写法,内有详细说明
- MYSQL 多表联合查询并分组的问题?
SELECT
ca.area_name as area_name2,
pd.biz_prdt_code as biz_prod_code2,
pd.product_name as product_name2,
ct1.level_1_name as level_1_name2,
date_format(tpg.EFF_DATE, '%Y-%m') AS efc_date2,
date_format(tcc.accident_time, '%Y-%m') AS acc_date2,
date_format(tcc.notice_time, '%Y-%m') AS ntc_date2,
ifnull(
date_format(tcc.close_date, '%Y-%m'),
'2014-01'
) AS cls_date2,
sum(tcc.closed_total_count) AS cls_tlt_cnt2,
0 AS pre_clm_amt_2,
0 AS pre_clm_cst_2,
sum(cash.AMOUNT) AS pre_sub_amt_2,
0 AS pre_svg_amt_2,
0 AS ced_clm_amt_2,
0 AS ced_clm_cst_2,
0 AS ced_sub_amt_2,
0 AS ced_svg_amt_2,
0 AS pst_clm_amt_2,
0 AS pst_clm_cst_2,
sum(cash.AMOUNT) AS pst_sub_amt_2,
0 AS pst_svg_amt_2
from
t_bcp_fee_detail fd
STRAIGHT_JOIN t_bcp_relation tbr ON tbr.DEBIT_ID = fd.FEE_ID
STRAIGHT_JOIN t_bcp_cash_fee_detail cash ON tbr.RELATION_ID = cash.RELATION_ID -- FORCE INDEX(IDX_CASH_FEE_DETAIL_RELATION)
INNER JOIN t_bcp_fee fee ON fd.TRANS_ID = fee.TRANS_ID
INNER JOIN t_clm_settle tcs ON tcs.SETTLE_ID = fee.SETTLEMENT_ID
INNER JOIN t_clm_settle_item tcsi ON tcsi.SETTLE_ID = tcs.SETTLE_ID
INNER JOIN t_clm_object tco ON tcs.OBJECT_ID = tco.OBJECT_ID
INNER JOIN t_clm_case tcc ON tco.CASE_ID = tcc.CASE_ID
INNER JOIN t_policy_general tpg ON tcc.POLICY_NO = tpg.POLICY_NO
INNER JOIN t_product_general pd ON tpg.PRODUCT_ID = pd.PRODUCT_ID
INNER JOIN t_circ_level1_map lm ON lm.product_code = pd.PRODUCT_CODE
INNER JOIN t_circ_ct_level_1 ct1 ON lm.level1_code = ct1.CT_LEVEL_1
INNER JOIN t_circ_area ca ON tpg.POLICY_SOURCE = ca.AREA_ID
WHERE
tcsi.RESERVE_TYPE = 'RC_04'
AND (tcsi.PAYMENT_STATUS = 40 OR tcsi.PAYMENT_STATUS = 20)
AND cash.DUE_POST_DATE >= '2014-01-01'
AND cash.DUE_POST_DATE < '2014-02-01'
GROUP BY
area_name2,
tcc.EXT_FIELD5,
biz_prod_code2,
efc_date2,
acc_date2,
ntc_date2,
cls_date2;