Implicit and Explicit Joins in Oracle SQL

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

Recently Posted

Apr 7 Solution for “Yarn build: Failed because of a stylelint error” Apr 7 Make sure your links have descriptive text Apr 7 How to add Laravel to WordPress using Sage theme (and install Tailwind CSS)? Apr 2 How to create a sidebar using pure CSS? Apr 1 How to switch dark and light themes using pure CSS? Apr 1 How to calculate elapsed time in JavaScript?

You might also like these

How to convert an HTML radio buttons into a toggle switch using CSS?CSSWhat’s a Web Storage API in JavaScript?JavaScriptThe Difference Between isNaN() Method And isNaN() Function In JavaScriptJavaScriptReverse a String in JavaScriptJavaScriptWhat is the difference between Loosely Typed Language and Strongly Typed Language?MiscHow to Block IPs and User Agents using code in Drupal or WordPress?DrupalThe Drupal flowDrupalKilling A Project Part 2: Who should make the decision to kill a project?MiscShould we ever delete data from a database?MiscHow to find the HCF or GCD and LCM of two given numbers using Swift?SwiftHow to Use Aggregate Functions (MIN, MAX, SUM, AVG, COUNT) to Summarize Data in SQL?SQL/MySQLWhat is the difference between let and var in Swift?Swift