I'm using sql server 2008. I'm trying to show a null result for amount and transdate, but still show the project name.

My query is:

```
select project, amount, transdate 
from rec 
where transdate>'2017-05-01' 
  and project like 'project%'

```

When I execute this I get no results, just blank. What I'd like to see is.

```
project 1 | null | null
project 2 | null | null
project 3 | null | null

```