Re: Simple update query from joined tables

On Thu, 1 Aug 2002 12:56:11 -0400, "Cornell news" <cornwell_at_clarityconnect.com> wrote:

>I have had a very difficult time trying to figure this out:
>
>How do I update a table value from another table with matching keys in a
>single UPDATE statement.
>
>Here's a scenario:
>
> Table_A has string fields String_1, and String_2
> Table_B has fields String_3
> Both tables have key fields key1
>
>Write an Update statement that concatenates the values of String_1 and
>String_3 - and places the result in String_2 field for matching (by Key1)
>rows in Table_A.
>
>So, for every matching Table_B row, update Table_A.String_2 field with the
>(Table_A.String_1||Table_B.String_3) value.
>
>
>TIA,
>Tim C.
>
>
>

How much do you pay for making your homework assignments?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 01 2002 - 13:08:19 CDT