I'm not 100% sure what you're after, I'll assume you want to find any records in the "leave" table for the attendance table.

SELECT a1.EmpID, COUNT(l1.LeaveID) as LeaveRecords FROM
Attendance a1 LEFT JOIN
Leave l1 ON l1.EmpID = a1.EmpID AND a1.Att_Date BETWEEN l1.LeaveFrom AND l1.LeaveTo
GROUP BY a1.EmpID

Does that suit your needs? The above would return a list of emp attendances and the no of leave records for that attendance date.