3 Replies Latest reply on May 7, 2017 6:18 PM by user19752

    FMSQL Update with Inner Join

    firebase

      I am seraching for a string that looks like this

       

      MBS( "FM.ExecuteSQL"; "

       

      UPDATE

          TEXT1

      INNER JOIN

          TEXT2

      ON

          TEXT_ID = ID

      SET

          Name = 'ABC'

      " ;"";"")

       

      I tried everything possible with aliases, setting the SET bevor the INNER JOIN etc. etc.