I'm not even sure this is possible but I'm trying to join two tables together but I'm not getting my expected results. My query is as follows:

```
SELECT inc.NUMBER as TICKET,
inc.UNIV_NUM,
inc.ASSIGNEE,
work.SUBMIT_DATE
work.TYPE
FROM dbo.HELP_DESK as inc
LEFT JOIN dbo.WORKLOG as work on inc.NUMBER = work.NUMBER
Where inc.ASSIGNEE = 'AB049732'
and work.SUBMIT_DATE = (Select MAX(work2.SUBMIT_DATE) 
                        from dbo.WORKLOG as work2 
                        where work2.NUMBER = work.NUMBER
                        and work2.TYPE = '16000')

```

My tables look like this

inc

```
+---------+-----------+----------+
| NUMBER  | UNIV_NUM  | ASSIGNEE |
+---------+-----------+----------+
|  100001 |   4321781 | AB049732 |
|  100002 |   4232756 | AB049732 |
|  100003 |   4322534 | AB049732 |
|  100004 |   4328534 | AB049732 |
+---------+-----------+----------+

```

work

```
+--------+------------+-------+
| NUMBER |   DATE     | TYPE  |
+--------+------------+-------+
| 100001 | 23/05/2018 | 16000 |
| 100003 | 22/05/2018 | 16000 |
| 100004 | 22/05/2018 | 16000 |
+--------+------------+-------+

```

My expected output is:

```
+--------+----------+----------+------------+-------+
| NUMBER | UNIV_NUM | ASSIGNEE |    DATE    | TYPE  |
+--------+----------+----------+------------+-------+
| 100001 |  4321781 | AB049732 | 23/05/2018 | 16000 |
| 100002 |  4232756 | AB049732 | NULL       | NULL  |
| 100003 |  4322534 | AB049732 | 22/05/2018 | 16000 |
| 100004 |  4328534 | AB049732 | 22/05/2018 | 16000 |
+--------+----------+----------+------------+-------+

```

But my actual output is:

```
+---------+-----------+----------+------------+-------+
| NUMBER  | UNIV_NUM  | ASSIGNEE |   DATE     | TYPE  |
+---------+-----------+----------+------------+-------+
|  100001 |   4321781 | AB049732 | 23/05/2018 | 16000 |
|  100003 |   4322534 | AB049732 | 22/05/2018 | 16000 |
|  100004 |   4328534 | AB049732 | 22/05/2018 | 16000 |
+---------+-----------+----------+------------+-------+

```

Effectively, number 100002 isn't displaying despite being in the inc table. Am I doing something wrong or is this a case of you can't join to something that doesn't exist?