{"author_url":"https://blog.hatena.ne.jp/devillikeaangel/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkkkw.hatenablog.jp%2Fentry%2F20071105%2F1194230665\" title=\"Select\u6587\u304b\u3089\u306eUpdate - kikukawa&#39;s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["SQL"],"width":"100%","url":"https://kkkw.hatenablog.jp/entry/20071105/1194230665","blog_title":"kikukawa's diary","image_url":null,"height":"190","published":"2007-11-05 11:44:25","title":"Select\u6587\u304b\u3089\u306eUpdate","blog_url":"https://kkkw.hatenablog.jp/","provider_url":"https://hatena.blog","description":"Select\u304b\u3089UpdateSQLServer UPDATE testTBL1 SET clm1= tbl2.clm1 FROM testTBL1 tbl1 JOIN testTBL2 tbl2 ON ( tbl1.Key1 = tbl2.Key1 ) WHERE ( tbl1.Key1 Like '%' ) AND ( tbl2.Key1 Like '%' )Oracle UPDATE ( SELECT tbl1.Key1 tbl1_Key1 , tbl1.clm1 tbl1_clm1 , tbl2.Key1 tbl2_Key1 , tbl2.clm1 tbl2_clm1 FROM test\u2026","type":"rich","provider_name":"Hatena Blog","author_name":"devillikeaangel","version":"1.0"}