Retrieve Data from same table from different tables

Hi,
I have databases A, B and C1, C2, C3.....
now I need to browse data from same table across C1, C2, C3.. databases.
the list of databases to retieve the same table data will come when I
join tables from database B and database A.
can anyone help me on this
Thanks
KiranKiran wrote:
> Hi,
> I have databases A, B and C1, C2, C3.....
> now I need to browse data from same table across C1, C2, C3..
> databases.
> the list of databases to retieve the same table data will come when I
> join tables from database B and database A.
> can anyone help me on this
>
Create a view that unions the tables you wish to query
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"