- 论坛徽章:
- 381
|
我帮楼主格式化下语句- select a.UserID as UserID,a.UserName as UserName,a.Gender as Gender,a.Age as Age,a.Marriage as Marriage,a.income as income, a.city as city,a.Telephone as Telephone,a.channel as channel,a.visitorID as visitorID,a.CreateTime as CreateTime,a.XPID as xpId,b.Code as Code, c.effective as effective,c.excellent as excellent,c.sale as sale,c.success as success,c.amount as amount,c.successTime as successTime
- from tab_Xpinfo as a left join tab_Markitinfo as b on a.VisitorID = b.vid
- left join detailClue as c on a.XPID=c.XPID
- where to_days(a.createTime) BETWEEN to_days(SUBDATE(now(),7)) and to_days(SUBDATE(now(),1))
- order by a.createTime DESC
- limit 0,20;
复制代码 |
|