"Krishnakumar S" <kk@discussions.microsoft.com> wrote in message
news:14BB1864-93B6-4442-BEC6-009C3E1FEA12@microsoft.com...
> Hi SAC
>
> Try this one
>
> UPDATE
> TWDECL
> SET
> LPROD = t2.LPROD, LQORD = t2.LQORD,
> FROM
> TWDECL t1
> INNER JOIN
> TWDECLTMP t2
> ON
> t1.LORD = t2.LORD And t1.LLINE = t2.LLINE
>
> --
> Krishnakumar S
>
>
> "SAC" wrote:
>
> > I need help with this sql syntax:
> >
> > UPDATE TWDECL
> > SET TWDECL.LPROD = TWDECLTMP.LPROD, TWDECL.LQORD = TWDECLTMP.LQORD,
> > FROM TWDECLTMP, TWDECL
> > WHERE TWDECLTMP.LORD = TWDECL.LORD And TWDECLTMP.LLINE = TWDECL.LLINE
> >
> > Not sure how to includ the second table in the syntax.
> >
> > Also, do I need to include the object's owner's name in this, too?
> >
> > Thanks.
> >
> >
> >