Witango-Talk: SQL DBMS Help

[Dan Stein]

Title: SQL DBMS Help

Would be nice to know the Alias thing but found my mistake in this one. No column define in 1st set line.


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





Update Verification.campaign

    Set Verification.campaign=Original_Outbound.campaign.DBCompany,

    Verification.campaign.NeverCallFlag=Original_Outbound.NeverCallFlag,

    Verification.campaign.AgentID=Original_Outbound.AgentID,

    Verification.campaign.VerificationAgentID=Original_Outbound.VerificationAgentID,

    Verification.campaign.CallResultCode=Original_Outbound.CallResultCode,

    Verification.campaign.DateTimeofCall=Original_Outbound.DateTimeofCall



        From Verification.campaign, Original_Outbound.campaign

            Where Original_Outbound.PhoneNum=Verification.campaign.PhoneNum

            and Original_Outbound.CallResultCode=12

            and Original_Outbound.PhoneNum Is Not Null


--
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