2 Replies Latest reply on Dec 3, 2018 11:22 AM by Paul Wachtler

    Using OR condition to join multiple columns from one table to another

    Wilson Siu

      I need to join multiple columns from 1 table to a specific column from another table, so it is going to be:


      [Table 1] . [Column A] = [Table 2] . [Column A]

      OR [Table 1] . [Column B] = [Table 2] . [Column A]

      OR [Table 1] . [Column C] = [Table 2] . [Column A]

      OR etc.


      Since I would have upward of 50 columns from Table 1 that needs to be joined, wondering if there is a workaround with the built-in join function? Especially since it requires a split function for the Table 1 field to get the necessary data.