9 Replies Latest reply: Jul 22, 2015 9:16 PM by arjun rao RSS

    How I can unite tables in script?

    Max Pol

      Good Day!

       

      I need help. I have 2 tables, that I load from SQL base (Table 1 and Table 2). I need to get in script Result Table 3. I need to add to Table 1 rows from Table 2 with values in Field A, that not include in Table 1. I prepare sample:

       

       

      Table 1
      Field AField B
      1A
      2B
      3C
      4D
      5E
      Table 2
      Field AField B
      4F
      5G
      6H
      7J
      8K
      Result Table 3
      Field AField B
      1A
      2B
      3C
      4D
      5E
      6H
      7J
      8K

       

      Thank you.