select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date"  from techunavailability ta

left join aaauser au on au.user_id=ta.technicianid

left join leavetypedefinition ltd on ltd.leavetypeid=ta.leavetypeid

left join dateunavailability du on du.leaveid=ta.leaveid

where du.leavedate >= <from_thisquarter> and du.leavedate <= <to_thisquarter>

order by 1