Results 1 to 2 of 2

Thread: Help on query

  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Help on query

    I have two tables Income(Date, IncomeType, Amount) and Expense(Date, ExpenseType, Amount). I want to create a balance sheet report for which need a query or view which creates a virtual table of form BalanceSheet(IncomeType, IncomeAmount, ExpenseType, ExpenseAmount). The table should look like:

    Salary 100000 Rent a Car 5000
    (null) (null) Tution 1000
    .................................................. ....
    .................................................. ....


    How can it be done?

    Appreciate for the help.

    Raju

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    select income, amount, '','' from incomes
    union
    select '','',expense, amount from expenses

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •