帮忙解析一下这个SQL语句~~~~特别是where后面的
select distinct a.proc_id,b.prop_val as '事由',c.prop_val as '车辆型号',d.prop_val as '出车时间',e.prop_val as '出车时间时',
f.prop_val as '出车时间分',g.prop_val as '回程时间',h.prop_val as '回程时间时',i.prop_val as '回程时间分',
j.role_reci as '出车司机'
from data_prop_inst a,data_prop_inst b,data_prop_inst c,data_prop_inst d,data_prop_inst e,
data_prop_inst f,data_prop_inst G,data_prop_inst h,data_prop_inst i,data_role_inst j
where
a.proc_id=b.Proc_id and b.prop_id=4 and
a.proc_id=c.Proc_id and c.prop_id=10 and
a.proc_id=d.Proc_id and d.prop_id=11 and
a.proc_id=e.Proc_id and e.prop_id=26 and
a.proc_id=f.Proc_id and f.prop_id=34 and
a.proc_id=g.Proc_id and g.prop_id=28 and
a.proc_id=h.Proc_id and h.prop_id=29 and
a.proc_id=i.Proc_id and i.prop_id=33 and
a.proc_id=j.proc_id and j.role_name='司机' and
a.proc_id in(select proc_id from proc_inst_all where piis_term=0 and data_refc=165 )
order by a.proc_id
该函数列表显示所有的派车单中的用户出车时间,其中司机字段需要获取角色数据