Forums
Smart Notification
Querying multiple infosets - duplicate warning
Author
Messages
mterlesky
New Member
Posts: 2
9/12/2014 8:10 PM
Hello - I've created an infoset in order to query the results of two other infosets following the instructions in this post:
https://www.lawsonguru.co...ft/8005/Default.aspx
I can run this query against the tables in MS SQL Server Mgmnt Studio with no issues. It returns merged data from the two infosets.
select a.COLUMN0,b.COLUMN1,a.COLUMN1,a.COLUMN2,a.COLUMN3
from INFOSET_1086 b, INFOSET_1087 a
WHERE a.COLUMN0=b.COLUMN0
When I place this code into my third infoset, I receive the following warning:
(dataengine: 1011) Ignoring attempt to add duplicate row to infoset.
If I sample on the third infoset, it shows only data from infoset_1087 only.
Any help on this would be greatly appreciated!
Thanks
Matt