22,210
社区成员
发帖
与我相关
我的任务
分享
select a.id,b.wip,c.create_date,c.type,c.id,c.acc,b.machine_name,b.machine_no,b.brand
from engine_project a
inner join engine_machine b on a.id = b.project_id
inner join engine_location c on c.wip = b.wip
where a.project_name = @projectName and DATE_FORMAT(c.create_date,'%Y-%m-%d') > '2016-08-14'