I am seraching for a string that looks like this
MBS( "FM.ExecuteSQL"; "
TEXT_ID = ID
Name = 'ABC'
I tried everything possible with aliases, setting the SET bevor the INNER JOIN etc. etc.
I just read that everything else but SELECT does not wirk in FQL but with exteren ODBC.
So I tried within the MBS Plug-In
But with no better result.
Hi firebase ,
in your query, you are missing table names to qualify the fields. For example:
TEXT1.TEXT_ID = TEXT2.ID
TEXT2.TEXT_ID = TEXT1.ID
See SQL UPDATE Statement
JOIN may be supported only in FROM clause.
You can use IN instead.
SET Name = 'ABC'
WHERE TEXT_ID IN (SELECT ID FROM TEXT2)
Retrieving data ...