I am new to sql. I have a problem where I have to display an additional column based on some condition on existing columns.
Existing table:

```
--------------------
 pid | ppid | path |
--------------------
111  | 120  | xyz  |
120  | 230  | abc  |

```

Where 'pid' -> processid , 'ppid' -> parent process id , 'path' -> path of process pid

I want to write a SQL query to display all these rows along with a new column 'ppath' which denotes the path of parent process. And this info can be retrieved from existing table itself.
But I am not sure how to do this.
Eg output:

```
--------------------------
 pid | ppid | path | ppath|
--------------------------
111  | 120  | xyz  | abc  |
120  | 230  | abc  |      |

```

Any suggestions would be helpful.