Yogesh Chauhan's Blog

Implicit and Explicit Joins in Oracle SQL

in SQL/MySQL on February 17, 2020

Implicit Joins

In simple terms, the "implicit join" simply lists the tables for joining (mostly using the FROM clause of the SELECT statement) as well as it uses commas to separate them. 

Implicit Joins Example

FROM employees, departments
WHERE employees.Department_no = departments.Department_no;

Explicit Joins

In simple terms, the "explicit join" uses the JOIN keyword to join two or more tables and the ON keyword to specify the predicates for the join. 

Implicit Joins Example

FROM employees JOIN departments 
ON employees.DepartmentID = departments.DepartmentID;

The explicit join is easier to read as well figure out what's happening in the query just by looking at it. The implicit syntax is a bit difficult and more prone to errors and is outdated.

Most Read

#1 Solution to the error “Visual Studio Code can’t be opened because Apple cannot check it for malicious software” #2 How to add Read More Read Less Button using JavaScript? #3 How to check if radio button is checked or not using JavaScript? #4 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #5 PHP Login System using PDO Part 1: Create User Registration Page #6 How to uninstall Cocoapods from the Mac OS?

Recently Posted

#Apr 8 JSON.stringify() in JavaScript #Apr 7 Middleware in NextJS #Jan 17 4 advanced ways to search Colleague #Jan 16 Colleague UI Basics: The Search Area #Jan 16 Colleague UI Basics: The Context Area #Jan 16 Colleague UI Basics: Accessing the user interface
You might also like these
How to set up the local environment and workspace for Angular development?AngularHow to create HTML elements with ID and class using JavaScript?HTMLUnderstand Inheritance in PHP in this Basic Example (For Beginners)PHPCheck if any column has NULL values in PostgresPostgresHow to scroll contents of a an element vertically using JavaScript?JavaScriptSocial Media Colors: LESS VariablesMiscellaneousWhen you don’t want to @forward every member in SCSS (Sass)SCSSHow does @extend rule work in SCSS (Sass)?SCSSWhat’s Interpolation in SCSS (Sass)?SCSSWhat is Conditional Rendering in React?ReactHow to make WordPress main stylesheet (style.css)?WordPressHow does AdSense calculate page loading time?JavaScript