I'm looking for a solution for a query that gives me 2 columns which get filled from 2 different where clauses .

UNIT TABLE

| timestamp | unit | status |
| --- | --- | --- |
| 31.12.2020 16:15 | UNIT1 | 1 |
| 31.12.2020 17:15 | UNIT1 | 2 |
| 31.12.2020 18:15 | UNIT2 | 1 |
| 31.12.2020 19:15 | UNIT2 | 2 |

and I'm looking for a result like this :

| unit | timestamp1 | timestamp2 |
| --- | --- | --- |
| Unit1 | 31.12.2020 16:15 | 31.12.2020 17:15 |
| Unit2 | 31.12.2020 18:15 | 31.12.2020 19:15 |

Something like

```
SELECT (SELECT timestamp from Unit WHERE unit_status = '1') ,
       (SELECT timestamp from Unit WHERE unit_status = '2')
FROM Unit

```

But it doesn't link properly, can you help me with this, I'm sure the solution is pretty easy but I don't get there.