{"id":78,"date":"2013-12-13T23:09:51","date_gmt":"2013-12-13T23:18:48","guid":{"rendered":"https:\/\/87e0aleft-outer-join-A.jpg"},"modified":"2015-07-16T19:15:13","modified_gmt":"2015-07-17T01:15:13","slug":"registros-no-coincidentes-entre-dos-tablas-con-mysql","status":"publish","type":"post","link":"https:\/\/emanuelpaxtian.com\/blog\/registros-no-coincidentes-entre-dos-tablas-con-mysql\/","title":{"rendered":"Registros no coincidentes entre dos tablas con mysql"},"content":{"rendered":"<p>Vamos a ver como hacer una consulta que a m\u00e1s de uno le ha vuelto loco alguna vez, extraer los registros NO conincidentes de dos tablas diferentes.<\/p>\n<p>\u00bfQui\u00e9n no se ha parado alguna vez a pensar como hacer una consulta que extraiga los registros que NO coinciden entre dos tablas?, pues la verdad es que es que es relativamente facil se puede resolver con dos sentencias usando la sentencia NOT IN<\/p>\n<pre class=\"brush: sql\">SELECT * FROM tabla WHERE campo NOT IN (SELECT campo2 FROM tabla2)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Vamos a ver como hacer una consulta que a m\u00e1s de uno le ha vuelto loco alguna vez, extraer los registros NO conincidentes de dos tablas diferentes. \u00bfQui\u00e9n no se&hellip;<\/p>\n","protected":false},"author":1,"featured_media":747,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-78","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":0,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/78\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media\/747"}],"wp:attachment":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media?parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/categories?post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/tags?post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}