Update column based on whether a row exists in another column

aijain28 · #1 (**permalink**) 03-17-11, 12:20

Hello,

I have table T1 with columns (A,B)
and table T2 with columns (C,D)

I wanted to do the following in plain english-

update T1 set B = 'Y'

if
exists (select 1 from T2 where T2.C = T1.A)

else

update T1 set B = 'N'

How can I do this in DB2?

ARWinner · #2 (**permalink**) 03-17-11, 12:52

Try this:

Code:

update t1 set b = case when exists (select 1 from T2 where T2.C = T1.A) then 'Y' else 'N' end

Andy

aijain28 · #3 (**permalink**) 03-17-11, 15:38

Thank you!

Internet Services

Web Development

Digital Marketing

Consumer Tech