i write this is the query

SELECT

distinct w.eID,

w.status,

COALESCE(al.CheckTime, c.[Date]) AS [Date]

,CASE WHEN NULLIF (CONVERT(VARCHAR(16), COALESCE(al.CheckTime, c.[Date]), 14), '00:00:00:000') IS NULL THEN 'A' ELSE 'P' END AS Attendance

FROM(

SELECTeID,status

FROMdbo.AttendLog

GROUP BYeID,status

) AS w

CROSS JOINdbo.Calendar AS c

LEFT JOINdbo.AttendLog AS al ON al.eID = w.eID

AND DATEDIFF(DAY, al.CheckTime, c.[Date]) = 0

where date='20130731'

but i am getting problem in employee name

how i write employee e.name in this query

when i write my ename in query my absnet data dont show