大连公司、烟台公司、长春(吉林)公司、深圳（惠州）

1.推荐客户

 1 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_141 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 2 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_142 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 3 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_143 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 4 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_144 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 5 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_145 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 6 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_146 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 7 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_147 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 8 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_148 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
 9 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_149 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
10 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_150 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) union all
11 SELECT FROM_UNIXTIME(RecommTime),FROM_UNIXTIME(AppointTime),FROM_UNIXTIME(expireTime),a.* from prm_Agent_Cst_Recommed_151 a where  projcode in (SELECT DISTINCT ProjCode FROM `0221zhenzhoi_copy`) ;
View Code

2.客户主档

posted @ 2016-06-21 20:17  侠之大者kamil  阅读(59)  评论(0)  编辑  收藏  举报