i found the solution.

But one question:

how do i use this output (dv.person) for left join.

I need to get some information of dv.person from other table and for that i need...

Thanks pietlinden

I want some modified result as below. Sorry for the changes. Please help with following.

+--------------+----------+-----------+

| Col1        |    Dr    |      Cr    |

+--------------+----------+-----------+

| PersonA...