{"id":1553,"date":"2012-12-25T10:00:32","date_gmt":"2012-12-25T15:00:32","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=1553"},"modified":"2014-11-13T13:50:13","modified_gmt":"2014-11-13T18:50:13","slug":"a-join-a-day-the-life-join","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/","title":{"rendered":"A Join A Day \u2013 The Life Join"},"content":{"rendered":"<div>\n<h3>Introduction<\/h3>\n<p>\nThis is the twenty-fifth post in my <a href=\"http:\/\/sqlity.net\/en\/1146\/a-join-a-day-introduction\/\">A Join A Day<\/a> series about SQL Server Joins. Make sure to let me know how I am doing or ask your burning join related questions by leaving a comment below.\n<\/p>\n<p>\nWith today's post I would like to take a brief break from the technical stuff and instead provide some life lessons that are too complex to be expressed in T-SQL. Because of that I did have to get some help:\n<\/p>\n<h3>Lisa's Musings<\/h3>\n<p>\nEarlier this week on a snowy Hamburg day I was sitting having tea with Sebastian and his parents when I mentioned to Sebastian that December 25th, Christmas Day, is a most important day for joins. With my knowing nothing about SQL, he of course was a bit skeptical. When I told him what I meant and that he should write about it, he (who has never been accused of being overly sentimental) told me that I should take a crack at writing it instead. So here goes\u2026\n<\/p>\n<p>\nAlthough Christmas Day is celebrated as a holy day for Christians around the world, it is a day symbolic of days in which people join to do something they love with someone they love. And as I get older, I have come to realize that by joining and sharing yourself in something greater than just you shouldn\u2019t be something that you do once a year. Your \u2018joining\u2019 day doesn't have to be a religious day, Christmas Day, or even December the 25th. It can be any day for any reason. Your day-to-join may occur frequently, last for several days, months, or years, or if you're very lucky \u2013 be every day that you live. So the day that something excites you, enlightens you, impassions you, humors you, or even maddens you -- and makes you want to share it with others \u2013 let that be the day you join in! Believe me, writing a \"Month of SQL Joins\" and sharing with a community as passionate as you are about SQL has been a month of Christmas Days for Sebastian. And even though he won\u2019t say it -- I know he believes it is in joining together that we as people can unite in creating a better world. Perhaps in the writing and reading of these blogs, you all can create a better SQL world. So in the spirit of the holidays, or whenever your Christmas days may be I wish you many happy days of \"joins\".\n<\/p>\n<p>\nTo close my little discourse on \u2018joins\u2019, I figured that it just wouldn\u2019t be right to leave out perhaps the best and most hopeful and worthy \"join\" ever -- for it is in the joining together of humans that we become humanity. In the words of the immortal John Lennon: \"Imagine all the people living life in peace. You may say I'm a dreamer, but I'm not the only one. I hope someday you'll join us, and the world will be as one.\"\n<\/p>\n<p>\nPeace to all, Lisa\n<\/p>\n<h3>A Join A Day<\/h3>\n<p>\nThis post is part of my December 2012 \"A Join A Day\" blog post series. You can find the table of contents with all posts published so far in the introductory post: <a href=\"http:\/\/sqlity.net\/en\/1146\/a-join-a-day-introduction\/\">A Join A Day \u2013 Introduction<\/a>. Check back there frequently throughout the month.\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Today&#8217;s post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.<\/p>\n<p> <a href=\"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[28,5,27],"tags":[],"class_list":["post-1553","post","type-post","status-publish","format-standard","hentry","category-a-join-a-day","category-general","category-series"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A Join A Day \u2013 The Life Join - sqlity.net<\/title>\n<meta name=\"description\" content=\"Today&#039;s post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Join A Day \u2013 The Life Join - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Today&#039;s post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2012-12-25T15:00:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:50:13+00:00\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"A Join A Day \u2013 The Life Join\",\"datePublished\":\"2012-12-25T15:00:32+00:00\",\"dateModified\":\"2014-11-13T18:50:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/\"},\"wordCount\":556,\"commentCount\":1,\"articleSection\":[\"A Join A Day\",\"General\",\"Series\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/\",\"name\":\"A Join A Day \u2013 The Life Join - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"datePublished\":\"2012-12-25T15:00:32+00:00\",\"dateModified\":\"2014-11-13T18:50:13+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Today's post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/1553\\\/a-join-a-day-the-life-join\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Join A Day \u2013 The Life Join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A Join A Day \u2013 The Life Join - sqlity.net","description":"Today's post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/","og_locale":"en_US","og_type":"article","og_title":"A Join A Day \u2013 The Life Join - sqlity.net","og_description":"Today's post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.","og_url":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2012-12-25T15:00:32+00:00","article_modified_time":"2014-11-13T18:50:13+00:00","author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"A Join A Day \u2013 The Life Join","datePublished":"2012-12-25T15:00:32+00:00","dateModified":"2014-11-13T18:50:13+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/"},"wordCount":556,"commentCount":1,"articleSection":["A Join A Day","General","Series"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/","url":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/","name":"A Join A Day \u2013 The Life Join - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"datePublished":"2012-12-25T15:00:32+00:00","dateModified":"2014-11-13T18:50:13+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Today's post is all about the life join. This multi-purpose join can be used to expand your horizons and maybe even help to make the world a better place.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/1553\/a-join-a-day-the-life-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"A Join A Day \u2013 The Life Join"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-p3","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=1553"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/1553\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=1553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=1553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=1553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}