Need Help for query

[Raju Shrestha]

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Daniel Morgan]

Raju Shrestha wrote:

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Seems like you are asking someone to do your homework for you.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

[Erland Sommarskog]

Raju Shrestha (ra**********@yahoo.com) writes:

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?

For this of question, please always include:

o CREATE TABLE statements for the involved tables.'
o INSERT statements with sample data.
o The expected output from the sample data.

The reason for this is that it reduces the amount of guessing for anyone
who is trying to help you. It also makes it possible to post a tested
solution.

Of course, if Daniel Morgan's assumption is right that this is a class
assignment, you should solve the problem on your own.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Raju Shrestha]

If everybody thinks (like Mr. Daniel Morgan) the questions in forum as
someones homework, the question raises for such forums and/or for the
need of that kind of people to participate in forums. Of course
sometimes the question might not be so clear to the others, in such case
better suggest for more details/specific like Erland did for which I am
thankful to him.

Regarding my question its not any homework. I gave those table examples
to make the question clear.I just wanted to know (if any) how two tables
(unrelated) can be joined by column without any duplication of records.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Erland Sommarskog]

Raju Shrestha (ra**********@yahoo.com) writes:

Regarding my question its not any homework. I gave those table examples
to make the question clear.I just wanted to know (if any) how two tables
(unrelated) can be joined by column without any duplication of records.

Again, I repeat from my previous posting:

For this of question, please always include:

o CREATE TABLE statements for the involved tables.'
o INSERT statements with sample data.
o The expected output from the sample data.

Else I would have to guess what you're aiming at.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp