Display all employee whether their Datetime(A

Display all employee whether their Datetime(A_Date) exit or

I want to display all employee whether their A_Date exit or not

here is ny data

create table #EmpMaster(EnrollNumber int, EmpName varchar(max))
Create table #AttendenceLOG (ID int,EnrollNumber int,A_Date datetime)
insert into #EmpMaster values (1001, 'Kashif'),(1002, 'Kami'),(1003, 'Ali'),(1004, 'Farhan'),(1005, 'Akhter'),(1006, 'Rehan'),(1006, 'Irfan')
insert into #AttendenceLOG values (1,1001, '2019-05-28 17:18'),(2,1002, '2018-05-28 17:18'),(3,1003, '2018-05-28 17:18'),(4, 1006,'2018-05-28 17:18')

My desire ouput

i tired below query but result is not coming which i want

1 Reply

Know the answer? Post it — somebody with the same question will find it here.