IDUG NA 2025

The joining of two or more tables in SQL is a great feature of the SQL language.  So often we need to combine data from more than one table into the same row output.  Depending on your logic needed, the language provides us with different types of joins.  This presentation starts off basic and builds into more in–depth logic and performance when having the need to process more than one table in a query. The different types of joins presented are: 
Inner Joins (Inner join vs comma delimited syntax) 
Left Outer Joins
Right Outer Joins
Full Outer Joins
Outer Joins with 'On clause Extensions'
Self Joins (Same table in FROM clause more than once)
This presentation will:

Take you deeper into SQL join logic
Help udertstand when specific joins are needed 
Understand the performance of joins
Understand 'On Clause Extensions' and when to use them
Understand the need for the same table in FROM clause more than once *Self Joins)