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 Solution to “TypeError: ‘x’ is not iterable” in Angular 9 #3 How to add Read More Read Less Button using JavaScript? #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

#Aug 15 Is PHP still good for back-end programming? #Aug 10 How to create a multisite network in WordPress? #Aug 3 How to create a circle that follows a cursor using JavaScript and CSS? #Aug 3 How to make a curtain slider using jQuery and CSS? #Aug 2 How to progressively load images and add a blurry placeholder? #Aug 1 How to create a placeholder loader (throbber) using CSS?
You might also like these
Default Values in SCSS (Sass)SCSSHow to import MySQL small sample database into phpMySQL?SQL/MySQLThe fundamental difference between HAVING and WHERE clauses in PostgresPostgresHow to change CSS with JavaScript?CSSHow to get user’s Browser and Operating Systems information using PHP?PHPWhat are CSS Specificity Rules and how does browser apply them?CSSHow to render Lists in React?ReactSolution to the error “Visual Studio Code can’t be opened because Apple cannot check it for malicious software”MiscellaneousHow to use HTML picture Tag?HTMLAggregate Functions Examples in Postgres for BeginnersPostgresHow to create a blurry text effect using CSS?CSSSolution to pod install fails with json error on Mac OS X 10.15 (or Mac OS Catalina)Miscellaneous