>
> "Derek Shi" <drkshih@hotmail.com> escreveu na mensagem
> news:011f01c3c07f$11f40450$a001280a@phx.gbl...
> > Isn't like this way:
> >
> > update table2
> > set pat_id = t1.pat_id
> > from table1 t1
> > where table2.login_pat = t1.login_id
> >
> > It should work.
> >
> > Derek
> >
> >
> > >-----Original Message-----
> > >Hi,
> > >
> > >I'm having a problem to update values in one table.
> > >
> > >I have one table:
> > >table1.login_id
> > >table1.pat_id.
> > >
> > >I have another table:
> > >table2.login_pat
> > >table2.pat_id.
> > >
> > >Table2.pat_id has values that I need to update in
> > table1.pat_id, where
> > >table1.Login_id = table2.login_pat
> > >
> > >Tried a lot, but can't find how to do this query... Can
> > someone help me?
> > >
> > >
> > >Regards,
> > >
> > >
> > >
> > >--
> > >Luiz Horacio
> > >lhoracio@iname.com
> > >
> > >
> > >
> > >.
> > >
>
>

> Isn't like this way:
>
> update table2
> set pat_id = t1.pat_id
> from table1 t1
> where table2.login_pat = t1.login_id
>
> It should work.
>
> Derek
>
>
> >-----Original Message-----
> >Hi,
> >
> >I'm having a problem to update values in one table.
> >
> >I have one table:
> >table1.login_id
> >table1.pat_id.
> >
> >I have another table:
> >table2.login_pat
> >table2.pat_id.
> >
> >Table2.pat_id has values that I need to update in
> table1.pat_id, where
> >table1.Login_id = table2.login_pat
> >
> >Tried a lot, but can't find how to do this query... Can
> someone help me?
> >
> >
> >Regards,
> >
> >
> >
> >--
> >Luiz Horacio
> >lhoracio@iname.com
> >
> >
> >
> >.
> >

> Try this..
>
>
> update table2
> set pat_id = t1.pat_id
> from table1 as t1
> inner join table2 as t2
> on t2.login_pat = t1.login_pat
>
>
>
> >
> > "Derek Shi" <drkshih@hotmail.com> escreveu na mensagem
> > news:011f01c3c07f$11f40450$a001280a@phx.gbl...
> > > Isn't like this way:
> > >
> > > update table2
> > > set pat_id = t1.pat_id
> > > from table1 t1
> > > where table2.login_pat = t1.login_id
> > >
> > > It should work.
> > >
> > > Derek
> > >
> > >
> > > >-----Original Message-----
> > > >Hi,
> > > >
> > > >I'm having a problem to update values in one table.
> > > >
> > > >I have one table:
> > > >table1.login_id
> > > >table1.pat_id.
> > > >
> > > >I have another table:
> > > >table2.login_pat
> > > >table2.pat_id.
> > > >
> > > >Table2.pat_id has values that I need to update in
> > > table1.pat_id, where
> > > >table1.Login_id = table2.login_pat
> > > >
> > > >Tried a lot, but can't find how to do this query... Can
> > > someone help me?
> > > >
> > > >
> > > >Regards,
> > > >
> > > >
> > > >
> > > >--
> > > >Luiz Horacio
> > > >lhoracio@iname.com
> > > >
> > > >
> > > >
> > > >.
> > > >
> >
> >
>
>