mysql - display one column data to two column 
===

Table A

slno | typename | typemode |

1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Act.Alw&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|    A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|

2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| Canteen&nbsp;&nbsp;&nbsp;&nbsp;|    D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|

I want to display two column according to its typmode

using union all I get

Addition | Deduction |

Act.Alw&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;Canteen&nbsp;&nbsp;&nbsp;|

I want display like this . Addtion and Deduction are alias

Addition | Deduction |

&nbsp;&nbsp;Act.Alw&nbsp;&nbsp;|&nbsp;&nbsp;Canteen&nbsp;&nbsp;|
