https://community.qlik.com/t5/Talend-Studio/Querying-MS-SQL-Dynamics-account/m-p/2325460#M95057 <P>It turns out you can also just query for account with the tDBInput component.</P> Thu, 11 Mar 2021 18:37:21 GMT JSey 2021-03-11T18:37:21Z https://community.qlik.com/t5/Talend-Studio/Querying-MS-SQL-Dynamics-account/m-p/2325459#M95056 <P>Hi</P><P></P><P></P><P>I need to pull data from a MS SQL database that was exported from MS Dynamics. Using the account example, there is techincally a accountbase table, and an accountExtension table. From SQL Server Management Studio, I can create query for only account and it would return rows from both tables. Is there a way to only query account in Talend Open Studio Data Integration (instead of having to query both accountbase and accountExtension)? Here is the schema from DB connection, showing both accountbase and account extension. Thank you for your suggestions.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0693p00000BXMcdAAH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153865iA5E6ED55B56A9EF0/image-size/large?v=v2&amp;px=999" role="button" title="0693p00000BXMcdAAH.png" alt="0693p00000BXMcdAAH.png" /></span></P> Sat, 16 Nov 2024 00:38:18 GMT https://community.qlik.com/t5/Talend-Studio/Querying-MS-SQL-Dynamics-account/m-p/2325459#M95056 JSey 2024-11-16T00:38:18Z https://community.qlik.com/t5/Talend-Studio/Querying-MS-SQL-Dynamics-account/m-p/2325460#M95057 <P>It turns out you can also just query for account with the tDBInput component.</P> Thu, 11 Mar 2021 18:37:21 GMT https://community.qlik.com/t5/Talend-Studio/Querying-MS-SQL-Dynamics-account/m-p/2325460#M95057 JSey 2021-03-11T18:37:21Z