AnsweredAssumed Answered

FMSQL Update with Inner Join

Question asked by firebase on May 7, 2017
Latest reply on May 7, 2017 by user19752

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.

Outcomes