members_tbl
id | Fullname | Email | MobileNo

attendance_in_tbl
id | member_id | DateTimeIN

attendance_out_tbl
id | member_id | DateTime_OUT

SELECT
attendance_in.EDatetime,
members_info.mfullname,
attendance_out.ODatetime
FROM
attendance_in
LEFT JOIN members_info ON members_info.id = attendance_in.MemID
LEFT JOIN attendance_out ON attendance_out.MemID = attendance_in.MemID
WHERE date(attendance_in.EDatetime) OR date(attendance_out.ODatetime) = "2014-03-10"

WHERE date(attendance_in.EDatetime)   /* wrong! */
    OR date(attendance_out.ODatetime) = "2014-03-10"

WHERE date(attendance_in.EDatetime) = "2014-03-10"
   OR date(attendance_out.ODatetime) = "2014-03-10"

WHERE (attendance_in.EDatetime  >='2014-03-10' AND
       attendance_in.EDatetime  < '2014-03-10' + INTERVAL 1 DAY)
   OR (attendance_out.EDatetime >='2014-03-10' AND
       attendance_out.EDatetime < '2014-03-10' + INTERVAL 1 DAY)