Title: SQL help Again
Update Verification.campaign
Set Verification.campaign.DBCompany=Original_Outbound.campaign.DBCompany,
Verification.campaign.NeverCallFlag=Original_Outbound.campaign.NeverCallFlag,
Verification.campaign.AgentID=Original_Outbound.campaign.AgentID,
Verification.campaign.VerificationAgentID=Original_Outbound.campaign.VerificationAgentID,
Verification.campaign.CallResultCode=Original_Outbound.campaign.CallResultCode,
Verification.campaign.DateTimeofCall=Original_Outbound.campaign.DateTimeofCall
From Verification.campaign, Original_Outbound.campaign
Where Original_Outbound.campaign.PhoneNum=Verification.campaign.PhoneNum
and Original_Outbound.campaign.CallResultCode=12
and Original_Outbound.campaign.PhoneNum Is Not Null
OK when I run the check it is OK but when I run the code it says invalid object in line 1
Verification.campaign
And second error
Invalid object name in line 1
Original_Outbound.campaign
So I’m sort of lost.
To recap.
Have two databases.
Verification
Original_Outbound
Need to update the Campaign table in Verification with data from Original Outbound.
Would love to use Table alias if I can because there are a boatload of columns ( not my design just try to do the DBMS for someone else)
Here is what I have but it does not work.
I always have trouble with the syntax when using two different DBO's
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
