Connect ODBC - Multiple individual tables with only selected fields

[Anonymous]

Hello,  

I'm trying to connect ODBC and have a question if it is possible to get certain fields from one table and all fields from other tables.

As it takes too much time to load data from saleitems, I want to get only necessary fields; FieldA and FieldB.

And I want all three tables be individual without joining which means, I don't want to inner join saleitems, account, and brand, but I should get three individual tables.

I've checked all the SQL statement, but seems like all are to join the tables to make a one merged table in the end.

Thank you in advance.

[amitchandak · Accepted solution]

@Anonymous , In connection advance property you have an option to give a query, you can create a new connection and add that table as query

[amitchandak · Accepted solution]

@Anonymous , In connection advance property you have an option to give a query, you can create a new connection and add that table as query

[Anonymous]

@amitchandak @vanessafvg 

Do you mean it is possible to separate the three queries for three tables with semicolon in the SQL Statement box?

So.. my query should be as below, right?

SELECT FieldA, FieldB FROM Org1.saleitems;
SELECT * FROM Org2.account;
SELECT * FROM Org2.brand;

 

[amitchandak · Accepted solution]

@Anonymous , No, The one where you want less column to create a connection query. rest two add as tables

[Anonymous]

@amitchandak  Ohhhhhh I got it!!!!

Thank you soooo much for your help!!!! 🙂

[vanessafvg]

hi can you clarify what you mean about checking the sql statement, do 3 different connections for the 3 tables, but write the sql code for each one in advanced options to reduce the load and push the compute back to the server the db is sitting on.