data from multiple databases

Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
I answered this yesterday in this same newsgroup.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184780384.310317.296780@.m37g2000prh.googlegr oups.com...
Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
|||On Wed, 18 Jul 2007 15:02:37 -0400, "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote:

>I answered this yesterday in this same newsgroup.
I think he is using Google Groups. When I checked a few minutes ago
nothing new appears there in .programming since mid-day yesterday.
Roy Harvey
Beacon Falls, CT