Getting Data from two table group wise

• dilip.aim11

  SSChasing Mays

  Points: 604

  More actions

  February 23, 2012 at 1:20 am

  #1450676

  Hello

  I am Able To do..

  By Using That Query

  select pu.Supplier_ID,pa.Purchase_ID,pa.Paid_amt

  into #temp1

  from tbl_Purchase pu

  inner join

  tbl_pur_Child pa

  on

  pu.Purchase_id =pa.Purchase_ID

  select Supplier_ID,sum(paid_amt) as Paid from #temp1 group by Supplier_ID