DB2 Update with join queries?

Normally, when I need to run these types of update queries, I use an EXISTS clause, like this: UPDATE data as a SET b_desc = p_desc, p_desc = null WHERE EXISTS (SELECT '1' FROM c_data as be WHERE b. B_desc = a. B_desc AND b.

P_desc = a. P_desc).

. Normally, when I need to run these types of update queries, I use an EXISTS clause, like this: UPDATE data as a SET b_desc = p_desc, p_desc = null WHERE EXISTS (SELECT '1' FROM c_data as be WHERE b. B_desc = a.

B_desc AND b. P_desc = a. P_desc).

X-Zero I don't think, AND b. P_desc = a. P_desc is needed in WHERE clause, which may restrict many updates.

@rozarWhat do you say? – Raja Reddy Nov 5 at 16:08 @RajaReddy - He had (what I took to be) an AND clause to begin with, so that's what I chose. – X-Zero Nov 7 at 16:34.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.