Simple update query from joined tables

From: Cornell news <cornwell_at_clarityconnect.com>
Date: Thu, 1 Aug 2002 12:56:11 -0400
Message-ID: <aibpsj$gsh$1@news01.cit.cornell.edu>

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. Received on Thu Aug 01 2002 - 11:56:11 CDT