I want to select ALWAYS a column in my view, and set it with CASES.
example:

```
SELECT isDone
,doneN

from...

```

I have to set isDone in this way:

```
if done is 1 isDone is 'yes'
if done is 0 isDone is 'no'

```

(doneN is a column from another table, isDone instead doesn't exist in other tables, so it's a "virtual" column)

Thank you in advice