8 Replies Latest reply: Jun 10, 2016 1:33 PM by Christopher Marlow RSS

    Joins based on multiple columns?

    Dinesh Karem

      Hi There,

       

      I do have 2 columns in table1 as below:

      Employee_ID,Meeting_x,Meeting_y

      101,0,1

      111,1,2

      121,3.3

       

      table2:

      Meeting_Identifier,Meeting_Desc

      0,Not Met

      1,Met Once

      2,Met Twice

      3,Met Thrice

       

      so I need two different charts on statistics of Meetingx and Meetingy lets say 2 ppl Not Met ,3 ppl Met Thrice !!

       

      I'm able to do it with a join on these two tables (Meeting_x & Meeting_Identifier) but I need join to happen on multiple columns from table 1 which also includes Meeting_y.

       

      Any help on this ?

       

      Thanks in advance !!