"David Portas" <snipped for brevity> wrote:
Example 1:[color=blue]
>
> UPDATE table_a
> SET col = ? /* Unspecified */
> WHERE EXISTS
> (SELECT *
> FROM table_b
> WHERE table_b.key_col = table_a.key_col )
>[/color]
<snip again>
Many thanks. I have used this sample extensively since you posted it. Hope
you (or someone) can help me with one more thing: How would it be written
to update several fields in table A with data from table B, where as you
have shown, a column matches the records?
TIA!
~ Duane Phillips.
Example 1:[color=blue]
>
> UPDATE table_a
> SET col = ? /* Unspecified */
> WHERE EXISTS
> (SELECT *
> FROM table_b
> WHERE table_b.key_col = table_a.key_col )
>[/color]
<snip again>
Many thanks. I have used this sample extensively since you posted it. Hope
you (or someone) can help me with one more thing: How would it be written
to update several fields in table A with data from table B, where as you
have shown, a column matches the records?
TIA!
~ Duane Phillips.
Comment