Re: Simple Query Help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: BMartins (beatriz_at_pred.com.br)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 13:47:18 -0300

UPDATE AM_Hist
        SET Am_Hist.CM_ID= Xref_import_Comp.CM_ID
    FROM AM_Hist, Xref_Import_Comp
 WHERE AM_Hist.CM_ID=Xref_Import_Comp.Imp_Comp_ID

Regards
BMartins (Brazil)

"Jeff York" <JeffYork@discussions.microsoft.com> escreveu na mensagem
news:5996AEAF-42E2-47A2-B455-23CD037F22B8@microsoft.com...
> This should be an easy one for someone(Other than me!) Thanks for the
help!
>
> I am trying to accomplish the following:
>
> Update AM_Hist
>
> set Am_Hist.CM_ID= Xref_import_Comp.CM_ID
>
> where AM_Hist.CM_ID=Xref_Import_Comp.Imp_Comp_ID
>
>
> How do I need to reference the Xref_Import_Comp table? I know I am going
to
> slap my head after this..Thanks!

Relevant Pages

  • Re: ds10l blowout
    ... Here there is the segmentation for reseller specialization: ... in CPQ time! ... You should not look only for Brazil. ... Regards ...
    (comp.os.vms)
  • Re: Move Web Page from one Doc Library to another
    ... > Hi, this is the easiest way to accomplish this task, with smigrate you can ... >>> You can use FrontPage 2003 to move this pages, ... >>> Regards, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Hibernate once - resume many
    ... Regards, ... > Use LsaRemoveAccountRights to revoke SE_SHUTDOWN_NAME privilege for all user accounts including admin accounts except the account ... I'd also love to know how they were thinking to accomplish that. ... >> standard shutdown dialog ...
    (microsoft.public.windowsxp.embedded)
  • Re: Printin from IE in Xp causes smartui error on server-only IE!!!!
    ... Regards, ... Mario - Brazil ... josmith wrote: ...
    (microsoft.public.windowsxp.setup_deployment)
  • Re: Countif in VBA -- evaluate multiple criteria
    ... Regards ... Is there a way to accomplish the same thing using this ... I can't get the following syntax to work: ... can I use the COUNTIF function to accomplish the same end ...
    (microsoft.public.excel.programming)