topic How to convert a query results to a new table? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-convert-a-query-results-to-a-new-table/m-p/2301007#M73175 <P>Hello,</P><P>I am new to Talend. I need help how I can make the following happen:</P><OL><LI>Create a query C by joining table A and table B from a data source (Oracle DB)</LI><LI>Convert query C results to a new table ( table C) in destination (Postgresql DB)</LI></OL><P></P><P></P><P>I have seen people did this without using tMap, but just used tDBinput / tDBoutput. can someone share what tool I can use to handle query from multiple tables and then convert the query results to a new table in destination DB?</P><P></P><P></P><P>Many thanks!</P><P>David</P> Mon, 19 Oct 2020 19:17:13 GMT wzhu 2020-10-19T19:17:13Z How to convert a query results to a new table? https://community.qlik.com/t5/Talend-Studio/How-to-convert-a-query-results-to-a-new-table/m-p/2301007#M73175 <P>Hello,</P><P>I am new to Talend. I need help how I can make the following happen:</P><OL><LI>Create a query C by joining table A and table B from a data source (Oracle DB)</LI><LI>Convert query C results to a new table ( table C) in destination (Postgresql DB)</LI></OL><P></P><P></P><P>I have seen people did this without using tMap, but just used tDBinput / tDBoutput. can someone share what tool I can use to handle query from multiple tables and then convert the query results to a new table in destination DB?</P><P></P><P></P><P>Many thanks!</P><P>David</P> Mon, 19 Oct 2020 19:17:13 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-a-query-results-to-a-new-table/m-p/2301007#M73175 wzhu 2020-10-19T19:17:13Z Re: How to convert a query results to a new table? https://community.qlik.com/t5/Talend-Studio/How-to-convert-a-query-results-to-a-new-table/m-p/2301008#M73176 <P>Hello,</P><P>Could you please have a look at this related topic to see if it helps?</P><P><A href="https://community.talend.com/s/question/0D53p00007vCnvLCAS/microsoft-sql-to-mysql-data-insertion-based-on-query-results" alt="https://community.talend.com/s/question/0D53p00007vCnvLCAS/microsoft-sql-to-mysql-data-insertion-based-on-query-results" target="_blank">https://community.talend.com/s/question/0D53p00007vCnvLCAS/microsoft-sql-to-mysql-data-insertion-based-on-query-results</A></P><P>Best regards</P><P>Sabrina</P> Thu, 22 Oct 2020 10:37:49 GMT https://community.qlik.com/t5/Talend-Studio/How-to-convert-a-query-results-to-a-new-table/m-p/2301008#M73176 Anonymous 2020-10-22T10:37:49Z