Hi,

I have an example and I could not find a solution for this

Table

Name Type Amount
Food Outcome 500
Salary Income 2500
Clothes Outcome 50
Rental Income 300
Car Outcome 80
Oil Outcome 50
.
.
.


and I need a result set for this like,

Name Amount Name Amount
Food 500 Salary 2500
Clothes 50 Rental 300
Car 80 null null
Oil 50 null null


2 column for Outcome and 2 column for income,

Pls, Becareful outcome count and income count may be different.

Thanks for your valuable help,

[Non-text portions of this message have been removed]