It is called table alias in SQL I think But anyway I tried what you
suggested and I get the error indicating I have an invalid object.
I thought your code would and should work just as is but it is not happening
and that is where I am confused. Somehow it seems to want the "Correlation
name" before the set statement but there is no way to do that as far as I
can tell.
Dan
--
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
> From: "Ben Johansen" <[EMAIL PROTECTED]>
> Organization: Intelisoft, Inc.
> Reply-To: [EMAIL PROTECTED]
> Date: Mon, 21 Oct 2002 17:05:05 -0700
> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
> Subject: RE: Witango-Talk: SQL DBMS Help
>
> Hi Dan,
>
> I think you mean Correlation-Name
> Which is usually accomplished in the From statement
>
> Example:
> Update Verification.campaign
> Set vc.DBCompany=oc.DBCompany,
> vc.NeverCallFlag=oc.NeverCallFlag,
> vc.AgentID=oc.AgentID,
> vc.VerificationAgentID=oc.VerificationAgentID,
> vc.CallResultCode=oc.CallResultCode,
> vc.DateTimeofCall=oc.DateTimeofCall
> From Verification.campaign vc, Original_Outbound.campaign oc
> Where oc.PhoneNum=vc.campaign.PhoneNum
> and oc.CallResultCode=12
> and oc.PhoneNum Is Not Null
>
> Sorry, can remember the sequence in SQLServer
> I think it is [database-name.][user-id.]table-name
> Example: Verification.dbo.campaign
>
> Chech the SQL Docs for From Clause
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
