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