Skip to main content

Introducing new learning courses and educational videos from Apress. Start watching

Outer Join

  • 1079 Accesses

Abstract

In the last chapter, we learned how to join tables together using the JOIN keyword. This was a type of join called an inner join, which displays records that exist in both tables being joined. The other type of join is an outer join.

This is a preview of subscription content, access via your institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • DOI: 10.1007/978-1-4842-4430-2_19
  • Chapter length: 11 pages
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
eBook
USD   34.99
Price excludes VAT (USA)
  • ISBN: 978-1-4842-4430-2
  • Instant PDF download
  • Readable on all devices
  • Own it forever
  • Exclusive offer for individuals only
  • Tax calculation will be finalised during checkout
Softcover Book
USD   44.99
Price excludes VAT (USA)
Figure 19-1
Figure 19-2
Figure 19-3
Figure 19-4

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and Permissions

Copyright information

© 2019 Ben Brumm

About this chapter

Verify currency and authenticity via CrossMark

Cite this chapter

Brumm, B. (2019). Outer Join . In: Beginning Oracle SQL for Oracle Database 18c. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4430-2_19

Download citation