I've tried everything to make the Expected Result to show as an Output but No Luck.

Sample Database

Table1 

```
 CalendarDate Date

```

Table2

```
User VarChar(50)
WDT DateTime

```

Table1 Records 

```
 CalendarDate
 2017-01-01
 2017-01-02
 2017-01-03
 2017-01-04

```

Table2 Record

```
 WDT                         User
 2017-01-01 08:00:00.000     User1
 2017-01-02 08:05:00.000     USer1

```

Expected Result

```
 User     CalendarDate    Status     WDT            Time
 User1    2017-01-01      Present    2017-01-01     08:00:00.000 
 User1    2017-01-02      Present    2017-01-02     08:00:00.000
 User1    2017-01-03      Absent     Null           Null
 User1    2017-01-04      Absent     Null           Null

```

I want to show the date even if there is no record on Table2 and then display the status if the Table2 is null on Table1 CalendarDate