asked on

SQL Query Problem

So I just need to do a quick restore of one column from my restore database to my production database. Thought I was close but I guess I wasn't. Here is what I'm trying:

USE ABC_ALL
UPDATE tblMembers
SET groupMembership = [dbo].[ABC_Restore].[tblMembers].[groupMembership]
FROM tblMembers INNER JOIN [dbo].[ABC_Restore].[tblMembers]
ON AddressID = [dbo].[ABC_Restore].[tblMembers].[AddressID]

Also tried:

UPDATE tblMembers
SET groupMembership= [dbo].[ABC_Restore].[tblMembers].[groupMembership]
WHERE AddressID = [dbo].[ABC_Restore].[tblMembers].[AddressID]

Figured one of them would have worked.

But instead of love I get:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.ABC_Restore.tblMembers'.

It's got to be something really simple easy.

dw9

ASKER CERTIFIED SOLUTION

Aneesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aneesh

DatabaseName. SchemaName.TbleName

dawho9

ASKER

OK, extra points now I guess. So this:

USE ABC_ALL
UPDATE tblMembers
SET groupMembership = [ABC_Restore].[dbo].[tblMembers].[groupMembership]
FROM [ABC_ALL].[dbo].[tblMembers] A INNER JOIN [ABC_Restore].[dbo].[tblMembers]
ON A.AddressID = [ABC_Restore].[dbo].[tblMembers].[AddressID]

executes fine but doesn't update anything? Does this look right? Basically, have a restore of a database and need to update the production side.

Thoughts.

dawho9

ASKER

Got it. For those who might need this in the future. Trying to update one table from another table in another table.

Thanks all!

USE GCM_ALL
UPDATE tblMembers
SET [signature] = R.[signature]
FROM [ABC_ALL].[dbo].[tblMembers] A JOIN [ABC_Restore].[dbo].[tblMembers] R
ON A.AddressID = R.[AddressID]