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

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
Is there a way to do a FULL OUTER JOIN in MySQL?SQL/MySQLHow to Create a Backup From Any Database in SQL?SQL/MySQLWhat are Big Data Clusters in SQL Server?SQL/MySQLForcing the domain to serve securely using HTTPSMiscellaneousCasting in PostgreSQLPostgresClasses in JavaScript: The BasicsJavaScriptHow to create a Progress Bar using JavaScript?JavaScriptHow to create a blurry text effect using CSS?CSSHow to add and remove list items using JavaScript?JavaScriptKilling A Project Part 3: How can an organization ensure that a doomed project is killed as early as possible?MiscellaneousA Step by Step Guide to Make RSS in XML For Any Website or Blog For FreeMiscellaneousHow to add recaptcha version 3 to PHP website?PHP