(RADIATOR) Executing SQL statement according to another SQL statement from diffrent database

[Herman verschooten]

Hi,

Are they on the same server? Or are the servers known to each other? In
that case you could use a stored procedure, or you could construct your
statement to perform a join on the 2 tables using the full name of the
tables, databasename.owner.tablename (eg Radiator.dbo.Subscribers), or
something like this:

Update Customer
Set A = 'a'
Where B in (Select B From Accounting.dbo.Acct)

Or if you need a value from ACCT, I guess it would be something like:

Update Customer
Set A = acct.Field