{"id":2029,"date":"2012-04-20T15:07:08","date_gmt":"2012-04-20T19:07:08","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=2029"},"modified":"2012-04-20T15:07:08","modified_gmt":"2012-04-20T19:07:08","slug":"find-missing-record-using-query","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2012\/04\/find-missing-record-using-query\/","title":{"rendered":"Find missing record using query"},"content":{"rendered":"<p>After running the query to update table records the record(s) is missing. Run this query to find the missing record.<\/p>\n<pre>\r\n<code>\r\nSELECT Table1.column\r\nFROM Table1\r\nLEFT JOIN Table2 ON\r\nTable1.column = Table2.Column\r\nWHERE Table2.column is NULL;\r\n<\/code>\r\n* Replace Table1 and *2 with your table names\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>After running the query to update table records the record(s) is missing. Run this query to find the missing record. SELECT Table1.column FROM Table1 LEFT JOIN Table2 ON Table1.column = Table2.Column WHERE Table2.column is NULL; * Replace Table1 and *2 with your table names<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,32,67],"tags":[30,95,146],"class_list":["post-2029","post","type-post","status-publish","format-standard","hentry","category-access","category-ms-sql","category-sql","tag-access-2","tag-missing-record","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2029"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=2029"}],"version-history":[{"count":2,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2029\/revisions"}],"predecessor-version":[{"id":2031,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2029\/revisions\/2031"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=2029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=2029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=2029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}