select t.taskid, t.manaidfk, p.execidfk,p.percent,t.endtime
from 任务信息表 t left join 任务进度表 p on t.taskid=p.t.taskidFk
where t.manaidfk='xxx'
and p.execidfk='zzz'
from 任务信息表 t left join 任务进度表 p on t.taskid=p.t.taskidFk
where t.manaidfk='xxx'
and p.execidfk='zzz'
select t.taskid, t.manaidfk, p.execidfk,p.percent,t.endtime
from 任务信息表 t left join 任务进度表 p on t.taskid=p.t.taskidFk
where t.manaidfk='xxx'
and p.execidfk='zzz'