question

bhavin_jani avatar image
bhavin_jani asked

MATRIX TYPE QUARY

PLEAS HELP ME I AM HAVING DATABASE AND I WANT TO CREATE REPORT THROUGH SQL QUARY AS BELOWED TABLE A FIELD IS ID,DESCRIPTION, INCOME, INCOME_DATE TABLE B FIELD IS ID,DESCRIPTION, EXPENSE, EXPENSE DATE I WANT TO CREATE REPORT LIKE BALANCE SHEET PLEASE HELP ME OR SUGGEST HOW TO DO AS I HAVE TRIED ALL THE SQL QUARY THAT I KNOW
t-sqlmicrosoft-accessreport-viewervb2005
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Based on what you've provided, there's no way to correlate the values from one table to the other. You need to have the ability to define what joins these tables. Since this is clearly homework, can you post the entire question so that it's more clear what's expected here?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.