See Message #1059535

>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?