Querying multiple infosets - duplicate warning

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