How to use two datasource in a single dataset?

I need to use two datasources in a single dataset query. When I use the database name.tablename I am getting the syntax is wrong error. Can you please help me on that? Can I use data source name in query or Do I need to create a separate data set for each data source?

Find more posts tagged with

Comments

mwilliams

Hi saravanam,

You can create two dataSets with your two dataSources, then create a joint dataSet to join the two dataSets from the different dataSources. Hope this helps.

saravanam

Thanks Williams. I can use the Joint data set as you have told.

mwilliams

Glad to help. Let us know whenever you have questions!