{"id":773,"date":"2015-03-18T13:35:51","date_gmt":"2015-03-18T04:35:51","guid":{"rendered":"http:\/\/systemdev.comsys-blog.com\/?p=773"},"modified":"2015-03-18T13:35:51","modified_gmt":"2015-03-18T04:35:51","slug":"sql-%e3%82%b8%e3%83%a7%e3%82%a4%e3%83%b3%e3%81%97%e3%81%a6%e6%9b%b4%e6%96%b0","status":"publish","type":"post","link":"https:\/\/tamura.jp\/?p=773","title":{"rendered":"SQL\u6587 \u30b8\u30e7\u30a4\u30f3\u3057\u3066\u66f4\u65b0"},"content":{"rendered":"<p>[TEXT]<br \/>\nupdate schedule set<br \/>\n      [full_name] = user_info_table.last_name + &#8216; &#8216; + user_info_table.first_name<br \/>\n   ,  [organization_name] = organization.organization_name<br \/>\n  FROM [dbo].[schedule]<br \/>\n  LEFT JOIN user_info_table ON user_info_table.user_info_table_id = schedule.user_info_table_id<br \/>\n  left join user_info_table_organization on user_info_table_organization.user_info_table_id = user_info_table.user_info_table_id and user_info_table_organization.default_flg = 1<br \/>\n  left join organization on organization.organization_id = user_info_table_organization.organization_id<br \/>\n  WHERE full_name is null AND user_info_table.user_info_table_id is not NULL<br \/>\n[\/TEXT]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[TEXT] update schedule set [full_name] = user_info_table.last_name + &#8216; &#8216; + user_info_table.first_n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[59,71,74],"class_list":["post-773","post","type-post","status-publish","format-standard","hentry","category-php","tag-join","tag-sql","tag-update"],"_links":{"self":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=773"}],"version-history":[{"count":0,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/773\/revisions"}],"wp:attachment":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}