1 Reply Latest reply on Apr 28, 2018 2:13 PM by Okechukwu Ossai

    Table Join without counting data for every repeat item

    Natalie Santana

      I have a table with gun incidents, states, and dates and another table with states, years, and number of gun laws. How can i join the table without blowing up the gun law count when i use the sum function? How can i merge the data to show the correlation between laws and incidents?

       

      Thank you!!!