https://community.sap.com/t5/application-development-and-automation-discussions/infoset-question/m-p/375353#M8735 <P>I am using SQ02 to create infoset, however it can only join tables by using join or left join. </P><P>Is it possible to be more feasible like a View that I can write free SQL (e.g. sub-query, more complex sql)?</P> Sat, 12 Nov 2016 09:30:09 GMT Former Member 2016-11-12T09:30:09Z https://community.sap.com/t5/application-development-and-automation-discussions/infoset-question/m-p/375353#M8735 <P>I am using SQ02 to create infoset, however it can only join tables by using join or left join. </P><P>Is it possible to be more feasible like a View that I can write free SQL (e.g. sub-query, more complex sql)?</P> Sat, 12 Nov 2016 09:30:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/infoset-question/m-p/375353#M8735 Former Member 2016-11-12T09:30:09Z https://community.sap.com/t5/application-development-and-automation-discussions/infoset-question/m-p/375354#M8736 <P>Free SQL only via external or integrated reading program. Cf SAP Library : <A href="http://help.sap.com/saphelp_nw70/helpdata/en/d2/cb45b2455611d189710000e8322d00/frameset.htm">Using Programs to Retrieve Data</A></P> Sat, 12 Nov 2016 10:27:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/infoset-question/m-p/375354#M8736 Sandra_Rossi 2016-11-12T10:27:18Z