Selecting data from multiple tables

Question

0.00/5 (No votes)

See more:

Hi All
I have a database named 'Master_Database'
It contain a table named 'tblDatabases'.
tblDatabases has a column 'DatabaseName' which contain data as
Database1
Database2
Database3

I have three databases named Database1,Database2,Database3
All of them have a table 'tblEmployees'

Now i want to fetch records from 'tblEmployees' table from all databases whose name are present in 'tblDatabases' table of 'Master_Database'

Thanks in advance
Richa Sharma

Posted 17-Mar-12 2:10am

Sharma Richa

Updated 31-Jul-12 3:15am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

andy(-RKO) · Answer 1 · 2012-03-17T03:46:00

Solution 1

Hello @Richa

I Think I might me possible with the query :

SQL

SELECT * FROM Database1.dbo.tblEmployees, Database2.dbo.tblEmployees, Database3.dbo.tblEmployees

Hope this will help you..

Posted 17-Mar-12 3:46am

andy(-RKO)

Comments

Sharma Richa 18-Mar-12 23:57pm

Problem is that i have to pick these database1,database2,database3 .....so on from 'Master_Database' dynamically

Selecting data from multiple tables

1 solution

Solution 1

Add your solution here

Preview 0

Selecting data from multiple tables

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us