2 Replies Latest reply on Mar 29, 2012 4:53 AM by Ranjan Sahoo

    How to create a custom join between two tables during datasouce connection?

    Ranjan Sahoo

      Hi,

       

      When i am trying to joing two tables, it is joining directly columns of two tables. But my issue is with i need to CONCAT two columns of one table to compare with another tables single column.

       

      Is this possible as we do in other tools.

       

      concat(Tab1.column,Tab1.column2)= Tab3.column1 is required.

       

      Thanks&Regards,

      Ranjan