ALTER TABLE t_bcp_cash_fee_detail ADD INDEX IDX_CASH_FEE_DETAIL_RELATION(RELATION_ID);
解决方案 »
- MysSql 报错如下,是什么原因?
- mysql中如何把04/02/11这种格式的字符串转换成时间数字
- 向mySQL写数据的问题
- 这个语句改怎么写 MYSQL中的查询语句 实现论坛帖子数统计的问题
- 安装mysql竟然出问题???~!~
- (寻高手讨论)MySQL5.1的连接缓存问题,菜鸟请浏览别参与讨论
- 请问查询结果怎么随机排序啊?
- 至急:请教一个SQL查询问题,谢谢!
- 关于建立ID号的问题(马上结贴)
- 請教:下載了 mysql4.1.0-win32-apache.zip ,解壓後發現沒有setup文件,我以前裝的mysql3.2.3安裝過後的目錄一樣,不知4.1的是如何安裝
- 求助一条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;