I tried to modify an existing letter in our iMIS 15.1. basically I want to add two new fields into the letter. Originally, the letter has fields from two table, say table A and B.
Now, I want to add two new fields from table C. I have set it up in iMIS, and modifed the Word file.
However, when I tried to merge it, it display this error:
GetMergeData - [Microsoft][ODBC SQL Server Driver][SQL Server]The objects "C" and "C" in the FROM clause have the same exposed names. Use correlation names to distinguish them.
Anybody knows how to fix this?
Appreciate your help.