This is the data inserted in those tables

SET IDENTITY_INSERT [voucher1] ON

INSERT [voucher1] ([srno], [vouchertype], [voucherprefix], [voucherno], [item], [itemdesc], [batchno], [quantity], [unit], [rate], [itemamt], [disc], [finalamt], [vatclass], [vat], [adtaxclass], [adtax], [total],...

Erin Ramsay (3/8/2013)

---

if on table has two months worth of data and the other has only one month what ARE you expected results? That you see only the complete information...

Jason-299789 (3/8/2013)

---

Ok, I take it you got an Error being reported about month?

select

[month]

,dramount

,cramount

from table1

...

This will display all months from t1 but not from t2

There is not any problem with column name.

The problem is when one table is having data for month which is not present in other table.

It wont work as one table is having data about single month and other is having data for two months.

select month,dramount,cramount from table1

left outer join table2

on table1.month=table2.month

Can you provide code for this?

I tried left outer join but with unexpected result

No pk-fk links

I am facing problem with one situation

If voucherDr table contains data of two months, i.e. March,April

and voucherCr table contains data of one month, March only

Then I am not getting expected...

🙂

Thank Vinu Vijayan

Thanks, this worked

Thanks, dwain

Next time I will be providing DDL also, Sorry for my question

Again thanks for your answer. I will test it. And let you know