select l.location, i.descr, i.lic_no, i.QOH,l.std_cpct STD,l.curr_cpct BEZET,l.exp_cpct Onderweg from locations l
left join v_inv_lic i on l.location = i.location
where work_zone  in ('TIP06','WII68','WIR06','WFC2D')
and l.status = 'A'

select l.location, l.std_cpct STD,l.curr_cpct BEZET,l.exp_cpct H_Onderweg, i.descr, i.lic_no, i.QOH, t.LIC_NO W_Onderweg, i.descr DESCR2 from locations l left outer join TASKS t on
l.location = t.dst_location left outer join v_inv_lic i on
i.lic_no = t.LIC_NO

where work_zone  in ('TIP06','WII68','WIR06','WFC2D')
and l.status = 'A'