I need to select two fields but with different conditions, I tried this:

```
SELECT 
(select my_field from my_table where another_field=1) as column_one,
(select my_field from my_table where another_field=2) as column_two;

```

but I got this error:

`Subquery returns more than 1 row`

is there a way to make this work?