<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Splunk Join is Left the same as outer in Splunk? in Splunk Search</title>
    <link>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581878#M202694</link>
    <description>&lt;P&gt;Is Type=Left the same as type=outer in Splunk?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If so why do they list it as three options?&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.splunk.com/Documentation/Splunk/8.0.4/SearchReference/Join" target="_blank" rel="noopener"&gt;https://docs.splunk.com/Documentation/Splunk/8.0.4/SearchReference/Join&lt;/A&gt;&lt;/P&gt;&lt;P&gt;type &lt;STRONG&gt;Syntax:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;type=inner | outer | left &lt;STRONG&gt;Description:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Indicates the type of join to perform. The difference between an&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;and a&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;left&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(or&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;outer) join is how the events are treated in the main search that do not match any of the events in the subsearch. In both inner and left joins, events that match are joined. The results of an&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;join do not include events from the main search that have no matches in the subsearch. The results of a&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;left&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(or&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;outer) join includes all of the events in the main search and only those values in the subsearch have matching field values. &lt;STRONG&gt;Default:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;/P&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;/DIV&gt;</description>
    <pubDate>Thu, 20 Jan 2022 11:55:15 GMT</pubDate>
    <dc:creator>robertlynch2020</dc:creator>
    <dc:date>2022-01-20T11:55:15Z</dc:date>
    <item>
      <title>Splunk Join is Left the same as outer in Splunk?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581878#M202694</link>
      <description>&lt;P&gt;Is Type=Left the same as type=outer in Splunk?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If so why do they list it as three options?&lt;/P&gt;&lt;P&gt;&lt;A href="https://docs.splunk.com/Documentation/Splunk/8.0.4/SearchReference/Join" target="_blank" rel="noopener"&gt;https://docs.splunk.com/Documentation/Splunk/8.0.4/SearchReference/Join&lt;/A&gt;&lt;/P&gt;&lt;P&gt;type &lt;STRONG&gt;Syntax:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;type=inner | outer | left &lt;STRONG&gt;Description:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;Indicates the type of join to perform. The difference between an&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;and a&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;left&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(or&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;outer) join is how the events are treated in the main search that do not match any of the events in the subsearch. In both inner and left joins, events that match are joined. The results of an&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;join do not include events from the main search that have no matches in the subsearch. The results of a&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;left&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;(or&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;outer) join includes all of the events in the main search and only those values in the subsearch have matching field values. &lt;STRONG&gt;Default:&lt;/STRONG&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;inner&lt;/P&gt;&lt;DIV class=""&gt;&lt;DIV class=""&gt;&amp;nbsp;&lt;/DIV&gt;&lt;/DIV&gt;</description>
      <pubDate>Thu, 20 Jan 2022 11:55:15 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581878#M202694</guid>
      <dc:creator>robertlynch2020</dc:creator>
      <dc:date>2022-01-20T11:55:15Z</dc:date>
    </item>
    <item>
      <title>Re: Splunk Join is Left the same as outer in Splunk?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581882#M202695</link>
      <description>&lt;P&gt;Left and outer are synonymous&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 20 Jan 2022 12:19:03 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581882#M202695</guid>
      <dc:creator>ITWhisperer</dc:creator>
      <dc:date>2022-01-20T12:19:03Z</dc:date>
    </item>
    <item>
      <title>Re: Splunk Join is Left the same as outer in Splunk?</title>
      <link>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581968#M202723</link>
      <description>&lt;P&gt;Here is a way to avoid joins in splunk&amp;nbsp;&lt;A href="https://community.splunk.com/t5/Splunk-Search/What-is-the-relation-between-the-Splunk-inner-left-join-and-the/m-p/391288/thread-id/113948" target="_blank"&gt;https://community.splunk.com/t5/Splunk-Search/What-is-the-relation-between-the-Splunk-inner-left-join-and-the/m-p/391288/thread-id/113948&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 21 Jan 2022 07:55:10 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Splunk-Search/Splunk-Join-is-Left-the-same-as-outer-in-Splunk/m-p/581968#M202723</guid>
      <dc:creator>isoutamo</dc:creator>
      <dc:date>2022-01-21T07:55:10Z</dc:date>
    </item>
  </channel>
</rss>

