Re: [Emerald] Multiple database query

Dale E. Reed Jr. ( (no email) )
Fri, 16 Jul 1999 10:33:52 -0700

Rick Richardson wrote:
>
> I need to select data from a column or two from one database in mssql
> and insert it into a different,
> matching database with different data.
>
> as in: select whatever from subaccounts in emerald.and insert it into
> emerald2
> I will be also adding new users in this way so what other columns will
> be affected?
>
> is this possible? and how is it possible?

select col1, col2, ...
Into Emerald2..table
from Emerald..Subaccounts

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart