cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nick93 Member
Member

Multiple tables for a single dataset

Hello,

 

I'm trying to create a data set from one of my data sources. I would like to import multiple tables from a database of SQL Server, but I am not able to do so. Do you know if it's possible? I don't want just a single table.

 

Thank you

 

Nick

1 ACCEPTED SOLUTION

Accepted Solutions
Jon-Heide Established Member
Established Member

Re: Multiple tables for a single dataset

Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.

1 REPLY 1
Jon-Heide Established Member
Established Member

Re: Multiple tables for a single dataset

Hi Nick - a data soruce is a connection to a single database, a data set is only one table. To use multiple tables, you either need to join then the SQL query (to create a single table) or use multiple datasets.