Re: Joining one to many relational table

UPDATE Table1 SET Table1.ColumnC = 1 FROM Table1 RIGHT JOIN Table2 ON
Table1.ColumnA = Table2.ColumnA AND Table1.ColumnB = Table2.ColumnB

"sqllearner" <sqllearner@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AAD3048F-15AA-4989-9109-88404D3E18F8@xxxxxxxxxxxxxxxx
> 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

  • 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)
  • 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. ...
    (microsoft.public.cert.exam.mcad)
  • 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. ...
    (microsoft.public.cert.exam.mcsa)
  • 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)
  • 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)