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


SELECT * 
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


SELECT *
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 How to check if radio button is checked or not using JavaScript? #2 How to add Read More Read Less Button using JavaScript? #3 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #4 How to uninstall Cocoapods from the Mac OS? #5 PHP Login System using PDO Part 1: Create User Registration Page #6 How to Use SQL MAX() Function with Dates?

Recently Posted

#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 #Jan 14 How to display a student’s individual transcript in Colleague? #Jan 11 How to install PuTTY on a MacOS?
You might also like these
Conditional operator in JavaScript (aka ternary operator)JavaScriptHow to remove border from :visited image, link or button?CSSFive common features of Angular template syntax (with examples)AngularIs there a CSS parent selector?CSSSafe Practice to add Links to cross-origin destinationUI/UXCROSS JOIN in PostgresPostgresWhat is React? Learn the basicsReactHow to make a curtain slider using jQuery and CSS?CSSDid you get an error while displaying Special Characters in JavaScript?JavaScriptHow to disable right click and drag and drop of images using jQuery?jQueryHow to define variables in SCSS (Sass)?SCSSThe flex-grow, flex-shrink and flex-basis Properties in CSSCSS