Joining one to many relational table

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?

Mike
Sat Jun 04 05:56:47 CDT 2005

"sqllearner" <sqllearner@discussions.microsoft.com> schrieb im Newsbeitrag
news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@microsoft.com...
>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

sqllearner
Sat Jun 04 17:20:02 CDT 2005

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@discussions.microsoft.com> schrieb im Newsbeitrag
> news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@microsoft.com...
> >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
>
>
>

Microcephalic
Sat Jun 04 19:06:21 CDT 2005

A word of advice:

What you've described has the look of a pile of string, all colored the
same, and it seems as though you are asking us to sort it out for you by
length.

An image, diagram, or chart would probably help you, or anyone looking to
help you, to visualize what you are looking to accomplish. Labels other than
'Table' and 'Column' would also make things somewhat simpler to identify,
even if they are disguised so as not to give away your intricate little
conspiracy. Otherwise you will only be spreading confusion and wasting
people's time.

If you are looking to spread confusion and waste people's time, I applaud
your efforts, as you have achieved a great success, albeit limited by your
choice of publication locale, and the fact that I enjoy wasting my time, so
you have only achieved a partial waste of my time, which is lame.

I had to think for you and I claim my $2.50 {?1}.

Microcephalic S. Bob



"sqllearner" <sqllearner@discussions.microsoft.com> wrote in message
news:AAD3048F-15AA-4989-9109-88404D3E18F8@microsoft.com...
> 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@discussions.microsoft.com> schrieb im
>> Newsbeitrag
>> news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@microsoft.com...
>> >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
>>
>>
>>

sqllearner
Sat Jun 04 19:43:01 CDT 2005

Dear Microcephalic S. Bob,

You hae already spent 100 words and some valuable (!) time to give advice
rather than give some idea to sole the problem. The message box do not take
table formating, thats why I need to explain the values in written format.
The main thing is that: You donot know the answer and try to blame other
people for that. Keep silent and do not waste your valuable time, if you
donot know the answer.

Microcephalic
Sat Jun 04 23:48:46 CDT 2005



"sqllearner" <sqllearner@discussions.microsoft.com> wrote in message
news:C37201DA-CF40-4A3A-ACC3-43BF4D96BA9F@microsoft.com...
> Dear Microcephalic S. Bob,
>
> You hae already spent 100 words and some valuable (!) time to give advice
> rather than give some idea to sole the problem.

First, my time is not valuable. I can type 100 words per minute. I slept
with your mother.

> The message box do not take
> table formating, thats why I need to explain the values in written format.

You're an imbecile. This has nothing to do with a message box. It's about
the fact that you have minimal to no communication skills, and that's why
you aren't going to get an answer to your problem. I'll add to this the fact
that you are in the wrong group to ask such a thing.

> The main thing is that: You donot know the answer and try to blame other
> people for that. Keep silent and do not waste your valuable time, if you
> donot know the answer.

I could figure out the answer, but you're not entitled to it if you're going
to try and blame me for the fact that you're too stupid to solve the problem
on your own instead of going to the wrong newsgroup and providing only
partial information.

It's not my job and not my responsibility to answer your problem.

Now you've made the fundamental mistake of attempting to insult someone who
was initially on your side, so you're on your own.

Microcephalic S. Bob
http://www.roblindman.com - elapsed time, 1 minute

Herb
Mon Jun 06 16:57:37 CDT 2005

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

"sqllearner" <sqllearner@discussions.microsoft.com> wrote in message
news:AAD3048F-15AA-4989-9109-88404D3E18F8@microsoft.com...
> 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@discussions.microsoft.com> schrieb im
>> Newsbeitrag
>> news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@microsoft.com...
>> >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
>>
>>
>>

The
Mon Jun 06 17:14:32 CDT 2005

No. He should have used XMLDOM to export the data, which he could have then
imported through a recordset object and recreated the table with a MAKE
SHIFT query, and he would be happier if he would have used velveeta instead
of real cheese.

Microcephalic S. Bob

"Herb" <herbert.v@yahoo.com> wrote in message
news:u4y2BLuaFHA.2516@TK2MSFTNGP10.phx.gbl...
> UPDATE Table1 SET Table1.ColumnC = 1 FROM Table1 RIGHT JOIN Table2 ON
> Table1.ColumnA = Table2.ColumnA AND Table1.ColumnB = Table2.ColumnB
>
> "sqllearner" <sqllearner@discussions.microsoft.com> wrote in message
> news:AAD3048F-15AA-4989-9109-88404D3E18F8@microsoft.com...
>> 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@discussions.microsoft.com> schrieb im
>>> Newsbeitrag
>>> news:82680BDA-7D58-4D78-A16B-2536F8AA0EC8@microsoft.com...
>>> >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
>>>
>>>
>>>
>
>

Kline
Tue Jun 07 02:56:04 CDT 2005

>But using joins, I found it updates all
>5 rows in Table1.Column3.

maybe you have your joins round the wrong way.....

Kline Sphere (Chalk) MCNGP #3

Frisbee®
Tue Jun 07 08:00:50 CDT 2005

"<!-- The F-Word --> <? echo "General Microcephalic S. Bob"; ?> <!--
Antisocial Interfaces --> // 270-290-291-293-294-298-299" <{
http://www.planetoftheheads.com/ - head first into the future }> wrote in
message news:OBfELUuaFHA.464@TK2MSFTNGP15.phx.gbl...
> No. He should have used XMLDOM to export the data, which he could have
> then imported through a recordset object and recreated the table with a
> MAKE SHIFT query, and he would be happier if he would have used velveeta
> instead of real cheese.

Bate! Everybody knows Velveeta IS real cheese.