Query Problem in SQl server 2005

SELECT
  dbo.SalePurchase.tran_date AS billdate
 ,LEFT(dbo.SalePurchase.tran_no, 1) + RIGHT(dbo.SalePurchase.tran_no, 8) AS BILLNO
 ,dbo.GL.AcName, Item_1.ItemName
 ,dbo.IT.iRate
 ,dbo.IT.iAmount AS amt
 ,Item_1.UOM
 ,dbo.IT.iQty
 ,dbo.SalePurchase.sp_dr
 ,AddressBook_1.FullName
 ,dbo.SalePurchase.sp_cr AS bamt
 ,GenMast_1.GenName AS itemgroup
 ,dbo.Item.ItemName AS subitem
 ,dbo.AddressBook.FullName AS tagidar
 ,GenMast_2.GenName AS city
 ,dbo.GenMast.GenName AS district
 ,salepurchase.sp_cr-salepurchase.sp_basic as tamt
FROM
 dbo.AddressBook
 RIGHT OUTER JOIN dbo.GenMast AS GenMast_2
 INNER JOIN dbo.GenMast ON GenMast_2.GroupCd = dbo.GenMast.Code
 RIGHT OUTER JOIN dbo.GL ON GenMast_2.Code = dbo.GL.CityCd ON dbo.AddressBook.Code = dbo.GL.TagadgirCd
 RIGHT OUTER JOIN dbo.SalePurchase ON dbo.GL.AcCode = dbo.SalePurchase.ac_code
 LEFT OUTER JOIN dbo.AddressBook AS AddressBook_1 ON dbo.GL.BrokerCd = AddressBook_1.Code
 LEFT OUTER JOIN dbo.Item
 RIGHT OUTER JOIN dbo.IT ON dbo.Item.Code = dbo.IT.SubItemCd ON dbo.SalePurchase.Code = dbo.IT.SPCode
 LEFT OUTER JOIN dbo.Item AS Item_1
 LEFT OUTER JOIN dbo.GenMast AS GenMast_1 ON Item_1.GroupCd = GenMast_1.Code ON dbo.IT.ItemCode = Item_1.Code
WHERE (salepurchase.sp_type='sr')
ORDER BY LEFT(dbo.SalePurchase.tran_no, 1) + RIGHT(dbo.SalePurchase.tran_no, 8)