https://communities.sas.com/t5/SAS-Enterprise-Guide/sub-query/m-p/622013#M35488 <P>dear all,</P> <P>I have a small dataset with 10 accounts which I try to use in the query builder in eGuide 5.1 in the where section as a subquery.</P> <P>The result I get is only data of the last account of this small dataset.</P> <P>&nbsp;</P> <P>What can be the problem that my query does not give data of all 10 accounts ??</P> <P>&nbsp;</P> Mon, 03 Feb 2020 19:10:33 GMT Jaheuk 2020-02-03T19:10:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/sub-query/m-p/622013#M35488 <P>dear all,</P> <P>I have a small dataset with 10 accounts which I try to use in the query builder in eGuide 5.1 in the where section as a subquery.</P> <P>The result I get is only data of the last account of this small dataset.</P> <P>&nbsp;</P> <P>What can be the problem that my query does not give data of all 10 accounts ??</P> <P>&nbsp;</P> Mon, 03 Feb 2020 19:10:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/sub-query/m-p/622013#M35488 Jaheuk 2020-02-03T19:10:33Z https://communities.sas.com/t5/SAS-Enterprise-Guide/sub-query/m-p/622015#M35489 Post your SQL so we can see what you're doing. Mon, 03 Feb 2020 19:21:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/sub-query/m-p/622015#M35489 tomrvincent 2020-02-03T19:21:51Z