Explanations of each of the join types are easy to understand with examples and sample data to use.
Understand the meaning and difference between Inner Join, Left/Right/Full Outer Join, Cross Join, Natural Join, Lateral, Cross Apply, Outer Apply, and Self Join.
Learn what those (+) signs in WHERE clauses are, how to understand them, and how to rewrite them using the standard JOIN syntax.
Learn the best practices for joins to get the correct data, write efficient queries, and improve the readability of your code.
Ben Brumm is the founder of DatabaseStar.com. He has 9+ years of experience in the software industry, and is an Oracle Certified SQL Expert.
Do you want to understand joins and improve the quality of your SQL queries?
Are you concerned that you only know the basics of how to join tables together?
Do you want to be able to write your queries easier, so you can get the results you want from your database?
Are you worried about asking coworkers embarrassing questions about Oracle joins?
This guide is a 30-page PDF file that lists examples, explanations, and best practices for Oracle SQL joins.
Joins are used in almost every Oracle SQL query I've written.
Knowing how to use joins will really improve your SQL and save you time when writing your queries.
Not knowing how the join types work and using the wrong joins will mean you'll spend more time trying to get your queries to work, and when they do work, they might not be the best queries they can be.