13 Replies Latest reply: Aug 9, 2017 1:01 PM by Supriya R RSS

    Get counts for each unique fieldvalues from multiple tables.

    Supriya R

      Hi,

       

      Table1:

       

      Batch_idInvitation_idComm_type_id
      213222
      313422
      313523
      213623
      313723
      313824

       

      Table 2:

      Batch_idInvitation_idComm_type_idUser_signed
      2132221
      3135231
      3137231
      4222220
      2136231
      3138240
      3134221

       

      From above tables, i want to get all  Comm_type_id  from Table1, and match invitation_id, Batch_id in Table2 where User_signed = 1 for each comm_type_id, find sum and append it to Table1

       

      I want to create table like this

      Batch_idInvitation_idComm_type_idsum(user_signed)
      2132221
      3134221
      3135232
      2136231
      3137232
      3138240

       

      How could i do this? Let me know if you need more info on this.