{"id":1321,"date":"2021-03-14T13:59:10","date_gmt":"2021-03-14T13:59:10","guid":{"rendered":"http:\/\/flace.de\/?p=1321"},"modified":"2021-03-14T14:28:56","modified_gmt":"2021-03-14T14:28:56","slug":"sql-update-join-beispiel-artikelstamm","status":"publish","type":"post","link":"https:\/\/flace.de\/?p=1321","title":{"rendered":"SQL Update join Beispiel Artikelstamm"},"content":{"rendered":"<p>Ein Update Befehl \u00fcber einen Join kann man wie folgt durchf\u00fchren:<\/p>\n<p><span style=\"color: #3366ff;\">update b<\/span><br \/>\n<span style=\"color: #3366ff;\">set b.kostenart = &#8217;19&#8216;<\/span><br \/>\n<span style=\"color: #3366ff;\">from artsatza a left join artsatzb b on b.schluessel = a.Schluessel<\/span><br \/>\n<span style=\"color: #3366ff;\">where a.bereich = &#8218;eig%*&#8216; and a.mengeneinheit=&#8217;Std&#8216; <\/span><\/p>\n<p>&#8211;and a.Kurztext1 like &#8218;%wartung%&#8216;<\/p>\n<p>Mit Update b wird die Tabelle definiert in der die \u00c4nderung erfolgen soll.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ein Update Befehl \u00fcber einen Join kann man wie folgt durchf\u00fchren: update b set b.kostenart = &#8217;19&#8216; from artsatza a left join artsatzb b on b.schluessel = a.Schluessel where a.bereich = &#8218;eig%*&#8216; and a.mengeneinheit=&#8217;Std&#8216; &#8211;and a.Kurztext1 like &#8218;%wartung%&#8216; Mit Update b wird die Tabelle definiert in der die \u00c4nderung erfolgen soll.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59,16],"tags":[],"class_list":["post-1321","post","type-post","status-publish","format-standard","hentry","category-artikelverwaltung","category-sql"],"_links":{"self":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/1321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1321"}],"version-history":[{"count":1,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/1321\/revisions"}],"predecessor-version":[{"id":1322,"href":"https:\/\/flace.de\/index.php?rest_route=\/wp\/v2\/posts\/1321\/revisions\/1322"}],"wp:attachment":[{"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flace.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}