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?