CODEWITHSUNDEEP
sqlsql-server
user3010406
user3010406

Reputation: 579

Update column based on existence in another column

I have two SQL tables. I am trying to conditionally update the second based on detecting existence of a value, URL in the this example, in the first.

The first table, Applications, has the following data:

URL
-------------------------     
http://stackoverflow.com        
http://stackoverflow.com

In the second table, Modernize, I have the following data:

URL                            FieldToUpdate
--------------------------------------------
http://stackoverflow.com        
http://stackoverflow.com

The expected result would be if a URL is detected in the first table, Application, that in the FieldToUpdate it would set the text "Yes". Otherwise, it would set FieldToUpdate to No.

Upvotes: 0

Views: 29

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269463

Use join:

update t
    set fieldtoupdate = (case when f.url is null then 'N' else 'Y' end)
from secondtable t left join
     firsttable f
     on t.url = f.url

Upvotes: 2

Related Questions