wanglei131(提问者)
SELECT
twd.sy_name as sName,
twd.vender_name AS iuName,
twd.ct_name AS ctName,
twd.ci_name AS ciName,
twd.report_date AS reportDate,
twd.md_outtruck AS outnum,
twd.md_outtunnage AS outtunnage,
twd.client_name AS cName,
twd.client_id AS cId,
tc.area_type areaType,
twd.mt_name AS mtName,
twd.ct_id AS ctId,
\'地销\' AS type
FROM
`t_weigh_dayreport` twd
LEFT JOIN t_client tc ON twd.client_id = tc.id
WHERE
1 = 1
and twd.mt_name =\'地销\'
and twd.sy_name =\'${sName}\'
and twd.report_date>= \'${stratDate}\'
and twd.report_date<= \'${endDate}\'
order by twd.report_date
1min目标场景问卷
立即参与
