9 Replies Latest reply: Mar 17, 2016 10:35 AM by Sunny Talwar RSS

    Comapre two tables

    Christian Seger

      Hi@all,

       

      i am searching for a peace of code which compares two tables and shows the average of the trainigsvisits.

       

      Tabel1 (Players):

      PlayerID     Name     Name2     Foot     Age    

      ID_001       Tom        Smith       Right     24

      ID_002        Sarah     Coy         Left       31

      ***

       

      Table2 (Games):

      PlayerID     GameID          Time              Lesson

      ID_001        Game_01       2016-12-01     1

      ID_002        Game_01       2016-12-01     1

      ID_001       Game_02        2016-12-08     2

       

      How can i compare if every player visited the each gameIDs.

      So i will display for Game_01 / 100% for Game_02 / 50 % and so on.

       

      Thanks

      CS