{"id":66,"date":"2024-01-31T13:09:36","date_gmt":"2024-01-31T12:09:36","guid":{"rendered":"http:\/\/techblog.joerg-klein.online\/?p=66"},"modified":"2024-11-20T11:05:00","modified_gmt":"2024-11-20T10:05:00","slug":"select-abfrage-mit-mit-join","status":"publish","type":"post","link":"https:\/\/techblog.joerg-klein.online\/?p=66","title":{"rendered":"SELECT Abfrage mit mit JOIN"},"content":{"rendered":"\n<p>Ich stand vor der Aufgabe ein bestimmtes Datum welches einem Rechner zugeordnet werden musste zu suchen. Leider stand in der einen Table (db2) der Rechnername und einer ID und in einer anderen Tabelle ebenfalls die ID und das gesuchte Datum. Also mussten die Tabellen mit <strong>JOIN <\/strong>verkn\u00fcpft werden. So in etwa:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>SELECT\u00a0<\/strong><em>datum<\/em><strong>\u00a0FROM<\/strong> <em>db_1<\/em>\u00a0<strong>JOIN <\/strong><em>db2<\/em> <strong>ON <\/strong><em>db1.ID<\/em>\u00a0= <em>db2.ID<\/em>\u00a0<strong>WHERE <\/strong><em>db2.suche\u00a0=\u00a0&#8217;suchtext&#8216;<\/em>\u00a0<strong>AND <\/strong><em>db2.bedingung<\/em>\u00a0<strong>IS\u00a0NOT\u00a0NULL<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ich stand vor der Aufgabe ein bestimmtes Datum welches einem Rechner zugeordnet werden musste zu suchen. Leider stand in der einen Table (db2) der Rechnername und einer ID und in einer anderen Tabelle ebenfalls&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":67,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,12],"tags":[],"class_list":["post-66","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein","category-sql"],"_links":{"self":[{"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/posts\/66","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=66"}],"version-history":[{"count":1,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/posts\/66\/revisions\/68"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=\/wp\/v2\/media\/67"}],"wp:attachment":[{"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=66"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=66"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techblog.joerg-klein.online\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=66"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}