Dick,
one last thought: as you come from DBF world, could it be, that addresses.remark is NOT null, but "" ?
Is it possible to merge info from 1 database into another using SQL
Re: Is it possible to merge info from 1 database into another using SQL
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
Re: Is it possible to merge info from 1 database into another using SQL
Hello Karl,
Interesting thought, but no, that doesn't change it. The problem is the AND after WHEN matched (ADS shows the position where the statement is wrong) and says there: Expected lexical element not found: THEN)
It seems to indicate that WHEN matched should be followed directly by a THEN, so any extra condition (using AND) fails.
Dick
Interesting thought, but no, that doesn't change it. The problem is the AND after WHEN matched (ADS shows the position where the statement is wrong) and says there: Expected lexical element not found: THEN)
It seems to indicate that WHEN matched should be followed directly by a THEN, so any extra condition (using AND) fails.
Dick