Outer Join

Definition - What does Outer Join mean?

An outer join in SQL is a specific kind of query construction that deliberately allows for a wider array of results. The process of building specific queries in SQL to get database results is a highly technical one, and an outer join is an example of a type of detail learned and utilized by database researchers.

Techopedia explains Outer Join

Someone who is writing a query can use a left or right outer join to include table results that only have a given component, rather than requiring multiple components to be present. A left outer join includes all rows in a table regardless of whether a specifically positioned column has results or not. By contrast, an inner join requires both components to be present.

Because outer joins provide for more diversity, they are often useful in searches that are less rigid and do not require strict adherence to the principle of having consistent data from multiple search components.

Share this:

Connect with us

Email Newsletter

Join thousands of others with our weekly newsletter

The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.