MySql Query to show rows as columns

See more:

MySQL

Hi,

I have two tables like Below..

Accounts - Table1

AccID   AccType
  1       A
  2       B
  3       C

Transactions - Table2

TrID	TrTo_AccID	TrAmount
100  	  1	         1000
100	  2	         2000
101	  1	         3000
101	  2	         4000
101 	  3	         5000

Now i need to get output like below..

TrID	A_Tr	B_Tr	C_Tr
100	1000	2000	null
101	3000	4000	5000

How can i write Mysql query to get this output.. Please help..

Thanks in advance...