update query

[patweb]

Hi, I have to tables.

1. T_TO_UPDATE
FIELD PWDFRAME "e.g. <sup>"
FIELD FRAMENAME empty but to update with the field
FRAMENAME from the T_TEMP_SOURCE
number of rows = 100

2. T_TEMP_SOURCE
FIELD PWDFRAME "e.g. "
FIELD FRAMENAME with data "e.g. [frmsup222]"
number of rows (20) is a group by from T_TO_UPDATE,
the content of the field PWDFRAME "e.g. " is more
then ones available in the table T_TO_

Question;

I like to update the field FRAMENAME in T_TO_UPDATE with the content of the field FRAMENAME from T_TEMP_SOURCE for each field where the field PWDFRAME is equal in the two columns. Can I do this with an update query ?

thanks, pat.</sup>

 

[PHV]

Something like this ?
UPDATE T_TO_UPDATE U INNER JOIN T_TEMP_SOURCE S ON U.PWDFRAME = S.PWDFRAME
SET U.FRAMENAME = S.FRAMENAME;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244