MS SQL Joins

Try joining the three table on CustName and Mth:

select a.CustName, a.Mth, a.tbbTotal, b.pendAmt, c.collAmt
from
Table_A a join Table_B b on (a.CustName = b.CustName and a.Mth = b.Mth)
join Table_C on (a.CustName = c.CustName and a.Mth = c.Mth)

Thanks for quick reply,
Sory to say, that your given sql not show propoer result. result set missing the value, due the inner join because month not matched in Table A , Table B and Table C. Still issue are pending..

Thanks to support all of you, finaly i got the solution as below..

select a.custName,a.mth,
(select tbbAmt from Table_A as X where x.custName=a.custName and x.mth=a.mth) as tbbAmt,
(select pendAmt from Table_B as X where x.custName=a.custName and x.mth=a.mth) as pendAmt,
(select collAmt from Table_C as X where x.custName=a.custName and x.mth=a.mth) as collAmt from
(select * from Table_A
union all
select * from Table_B
union all
select * from Table_C
) as a

Again thanks to all...
Have nice days

Sunil Kumar Singh


UPDATE (Sandeep):
I think you should not use the above query. It's too costly relative to one I had suggested. You can avoid inner/sub queries.

Here you go...

SELECT 
   CustName, Mth, tbbTotal, 0 AS pendAmt, 0 AS collAmt
FROM 
   TableA

UNION 

SELECT
   CustName, Mth, 0 AS tbbTotal, pendAmt, 0 AS collAmt
FROM
   TableB

UNION 

SELECT
   CustName, Mth, 0 AS tbbTotal, 0 AS pendAmt, collAmt
FROM
   TableC