https://community.qlik.com/t5/Talend-Studio/Use-Subquery-in-tSalesforceInput-component/m-p/2349784#M116715 Hi&nbsp; <BR />You need to extract data from the two modules and do a join on tMap. <BR /> <BR /> <BR />Regards <BR />Shong Mon, 10 Oct 2016 08:16:52 GMT Anonymous 2016-10-10T08:16:52Z https://community.qlik.com/t5/Talend-Studio/Use-Subquery-in-tSalesforceInput-component/m-p/2349783#M116714 <P>Hi, Can i use a subquery in tSalesforceInput component to extract Account along with its Contacts. For Example -(select id, Name, (select id, FirstName, LastName from Contacts) from Account) and what should be the Schema defined in the component to read all the Contacts related to a particular Account.</P> Fri, 30 Sep 2016 06:47:42 GMT https://community.qlik.com/t5/Talend-Studio/Use-Subquery-in-tSalesforceInput-component/m-p/2349783#M116714 Anonymous 2016-09-30T06:47:42Z https://community.qlik.com/t5/Talend-Studio/Use-Subquery-in-tSalesforceInput-component/m-p/2349784#M116715 Hi&nbsp; <BR />You need to extract data from the two modules and do a join on tMap. <BR /> <BR /> <BR />Regards <BR />Shong Mon, 10 Oct 2016 08:16:52 GMT https://community.qlik.com/t5/Talend-Studio/Use-Subquery-in-tSalesforceInput-component/m-p/2349784#M116715 Anonymous 2016-10-10T08:16:52Z