SQL 语句如何写

Question

现在有2个表TABLE1 URL                                  TITLE
HTTP://WWW.BAIWU.COM                 百渡
Http://www.sina.com                  新浪
------------
TABLE2 URL                               TITLE
HTTP://WWW.BAIDU.COM              null
HTTP://WWW.SINA.COM               nuLL请问如何写SQL语句将表1中的TITLE正确的写入到表2中 

Answer 1

.....
update TABLE2
 set TITLE =TABLE1.TITLE 
   from TABLE1,TABLE2
     where TABLE1.URL =TABLE2.URL

Answer 2

UPDATE TABLE2
SET TABLE2.TITLE = TABLE1.TITLE
FROM TABLE1 INNER JOIN TABLE2 ON UPPER(TABLE1.URL) = UPPER(TABLE2.URL)

Answer 3

update table1
set title=table2.title
from table2
where
table1.url=table2.url