Sum query two table

• mrsiro

  Old Hand

  Points: 376

  More actions

  July 15, 2021 at 3:33 am

  #3908103

  Hello guys, i have table in and out, how to query get result.

  

• ktflash

  Default port

  Points: 1400

  More actions

  July 15, 2021 at 4:17 am

  #3908104

  This should do the trick:

  Identify the columns you want to group by --> ID_Order, ID_Product from either table

  Identify the columns you want to aggregate --> IN.Amount, Out.Amount

  Identify the columns you need to join Table IN and Out --> ID_Order, here maybe you also need ID_Product depending on your data structure

  select In.ID_Order
        ,In.ID_Product
        ,IN_Sum=sum(IN.Amount)
        ,Out_Sum = sum(OUT.Amount)
  from Table_IN IN 
       inner join Table_Out OUT on IN.ID_Order = Out.ID_Order
  group by IN.ID_Order
          ,IN.ID_Product

   

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help