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

    Concatenate two fields from two different tables SQL

    Enrique Xu



      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.