Retrive only some tables from DATASET with SQL

[Anonymous]

Hi, I´m trying to retrive only some tables from a large ERP database with lots of tables (hundreds).I want to do it with the SQL Editor because they are a ton..  I tried to use diferent SELECT SQL queries. I don´t want to open multiple connections to the same database. Thank you!

[vanessafvg · Accepted solution]

@Anonymous  Hi Tom I am afraid SQL editor isn't available, i think you need to figure it out in SQL first if you dont know what you want to bring back.

[JimOnTheAve]

I have a similar need.  I am looking to create multiple datasets using multiple queries with one connection.  For Example, Click "Get Data" and write 2 SQL statement to end up with 2 enitities when I look at them in the Model or Data section.  It seems like I have to "Get Data" for Each Sql statement.  Is this true?

[Anonymous]

It seems that there is no way to open 2 specific tables in same connection with the SQL editor