Page 2 of 2
Re: Is it possible to merge info from 1 database into another using SQL
Posted: Tue Jul 16, 2024 1:02 pm
by FFF
Dick,
one last thought: as you come from DBF world, could it be, that addresses.remark is NOT null, but "" ?
Re: Is it possible to merge info from 1 database into another using SQL
Posted: Wed Jul 17, 2024 9:20 am
by ic2
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