Скачать или смотреть Oracle SQL Different Join Syntax | Oracle SQL fundamentals

Joins are used to combine #data from multiple tables to form a single result set. #Oracle provides two approaches to joining tables, the non-ANSI join #syntax and the #ANSI join syntax, which look quite different.
The non-ANSI join syntax has historically been the way you perform #joins in Oracle and it is still very popular today. The tables to be joined are listed in the #FROM #clause and the join conditions are defined as predicates in the #WHERE clause. Even if you don't like it, you are going to have to get used to it as there is a lot of #code out there that still uses it.
If you are not familiar with the syntax you will struggle to bug fix any existing code and some of the examples on the internet will look rather mysterious to you.

1:19 types of joins
1:47 join syntax
2:40 traditional syntax joining

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis