3 Replies Latest reply: Jan 23, 2017 7:54 AM by Enrique Xu RSS

    Concatenate two fields from two different tables SQL

    Enrique Xu

      Hello,

       

      I would like to concatenate two fields from two different tables loaded from an SQL database.

      In order to clarify, I am going to put an example:

      Field1 from Table1

      Field2 from Table2

      What I want to obtain is a

      Field3 that is Field1_Field2

       

      I know if Field1 and Field2 comes from one table, the script would look like this:

       

      LOAD Field1 &'_'& Field2

      From whatever.database.Table1

       

      But in the case of having two tables, I dont know how to proceed. I would appreciate so much if you can help me on this.

       

      Best regards.