CROSS JOIN

- [Instructor] 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 both those tables. But what if you want to join two tables on no columns? A cross join in the from clause joins two or more tables and returns rows in the join from both tables and returns every combination of rows from both tables. I'll show an example and make it clear that there are not too many use cases for cross join. 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 join, along known as full outer join. Natural join and cross join. I'll review cross join in this video. Here are the comparable syntaxes between the ANSI standard and Oracle-specific syntax for cross joins and the equivalent syntax using Oracle native joins without actually joining on specific columns in the where…