Re: Joining one to many relational table

For Table1 the values for column1 is A,A,B,B,B and the correspoding values in
column2 is 2,2,3,3,3 and the correspoding values in column3 is 0,0,0,0,0. In
Table2 the values for column1 is A,B and the correspoding values in column2
is 2,3.

I want to update Table1.Column3 = 1, where Table1.Column1 = Table2.Column1
and Table1.Column2 = Table2.Column2. But using joins, I found it updates all
5 rows in Table1.Column3. But I want to update only 2 rows in Table1.Column3,
as Table2 has 2 rows. More specifically, I want to update one to one in this
one to many relational tables.


"Mike T." wrote:

> "sqllearner" <sqllearner@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
> news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@xxxxxxxxxxxxxxxx
> >I have two tables: Table1 has A,A,B,B,B and Table2 has A, B. I want to join
> > Table1 with Table2 and update Table1, but I want to update only 1 for A
> > and 1
> > for B in Table1. How will I do it?
>
>
> Are A,A,B,B,B values for one column across 5 rows in Table1? Are there other
> columns in Table1?
>
> For the joins, SELECT DISTINCT might be an option. For the update, I need
> more info.
>
> Also, to use a New York phrase: Not for nothin', but this is the MCSE group.
> You might have a bit more luck with one of the SQLServer groups.
>
> --
> Mike T.
> MCNGP #XLI
>
>
>
.

Relevant Pages

  • Re: Joining one to many relational table
    ... Table1 has A,A,B,B,B and Table2 has A, B. I want to join ... > for B in Table1. ... > For Table1 the values for column1 is A,A,B,B,B and the correspoding values ...
    (microsoft.public.cert.exam.mcad)
  • Re: Joining one to many relational table
    ... > For Table1 the values for column1 is A,A,B,B,B and the correspoding values ... > as Table2 has 2 rows. ... >>> for B in Table1. ...
    (microsoft.public.cert.exam.mcse)
  • Re: Joining one to many relational table
    ... >> For Table1 the values for column1 is A,A,B,B,B and the correspoding ... >> as Table2 has 2 rows. ... >>> You might have a bit more luck with one of the SQLServer groups. ...
    (microsoft.public.cert.exam.mcse)
  • Re: Joining tables
    ... Table1 has A,A,B,B,B and Table2 has A, B. I want to join ... > for B in Table1. ... > For Table1 the values for column1 is A,A,B,B,B and the correspoding values ...
    (microsoft.public.cert.mcdba)
  • Joining tables
    ... For Table1 the values for column1 is A,A,B,B,B and the correspoding values ... as Table2 has 2 rows. ...
    (microsoft.public.cert.mcdba)