Hello Guys!

Using SQLServer 2000, I have a table called tranledger with columns amount, trantype, custno. I want to create a select statement wherein I could be able to separate amount as debit and amount as credit where trantype = 1 and 2 respectively. So instead of having 2 select statement to get the desired output, I want to have one select only. Would it be possible?

Select amount as debit from tranledger Where trantype = 1 
Select amount as credit from tranledger where trantype = 2

How can I have a single select statement based on the 2 statements above?