Hi I'm trying to write a query like this:

select
(update Table2 set Table2.Column1 = TableA.Column1)
from TableA

The idea is that for each row the select query returns it will update Table2 with the value from TableA.Column1.

I was able to do it in SQL Server, however I don't know how in DB2.

Thanks.

Maybe in Version 11 ?
Now most closer to your dream is MERGE statement....

Lenny

Which row(s) in Table2?

In standard SQL that should look something like You will need to insert the condition that correlates each row in Table2 with at most one row in TableA, of course.

Lenny, I think you hit the nail on the head. I browsed through the DB2 documentation on the merge command, but I didn't see it mention how it would handle a many to 1 or even many to many set.

For example:
With match you use something like this: ON ( table1.Column1 = table2.Column1 )
what happens if Table1 and/or Table2 contain non-distinct/non-unique values that we are comparing?

Tonkuma:

I don't understand your question. If there are 10 rows in TableA and 10 rows in TableB, then the answer is 10 rows. Obviously I could filter it down further like with the match and its "on" keyword.

n_i: Duh! I should have known that! That works as well, and that's probably what I was thinking of. Thank you.

The question really is, how YOU would handle such situations. You can always come up with an SQL statement that implements your rules, but you must have those rules in the first place.

Use On(1 = 1)

Lenny