From the course: Oracle Database 19c: Basic SQL
Join today to access over 25,500 courses taught by industry experts.
LEFT (OUTER) JOIN
From the course: Oracle Database 19c: Basic SQL
LEFT (OUTER) JOIN
- [Man] One of the key components of a select statement is the ability to join two or more tables on one or more columns and return columns from those tables. A left outer join, or just left join, in the FROM clause joins two or more tables and returns rows in the join from the table on the left of the join and returns matching rows from the other table if there is a match. I'll describe how that works and compare the ANSI syntax to the Oracle specific syntax. Here are the join types you can perform in a select statement in Oracle. An inner join, also known as join. A left join, also known as left outer join. A right join, also known as right outer join. Full outer join. Natural join. And cross join. I'll review the left outer join in this video. Here are the comparable syntaxes between the ANSI standard and Oracle specific syntax for left outer joins, both fully supported in Oracle. In each syntax I've highlighted the statements that enable the corresponding syntax. The ANSI syntax…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.