Querying multiple infosets - duplicate warning

 0 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
mterlesky
New Member Send Private Message
Posts: 2
New Member
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