update script help

[mkey]

Hi All,
My Script looks something like this.

SELECT a.id, a.name, a.type, b.alias, a.site_id
FROM site a INNER JOIN site_name_alias b ON a.id = b.site
WHERE ((a.id >1000000) And (a.id < 1999999) AND (a.name Is Null));

Now what I want to do is an update on the a.name to be the same as b.alias. Because right no the a.name is null value.
Thank you!

 

[kim1]

Hi,

Update site a
set a.name = b.alias
from site a INNER JOIN site_name_alias b ON a.id = b.site
WHERE ((a.id >1000000) And (a.id < 1999999) AND (a.name Is Null))


Kim