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 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 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
How to create a multisite network in WordPress?WordPressDISTINCT ON: The confusing, unique and useful feature in PostgresPostgresHow to get user’s Browser and Operating Systems information using PHP?PHPWordPress: How to find all posts from a custom post type with multiple custom fields values?WordPressCreate a simple bar chart and column chart using pure CSS gridCSSHow to Display Related Posts in WordPress?WordPressHow to create a circle that follows a cursor using JavaScript and CSS?CSSShould we ever delete data from a database?MiscellaneousHow to display random posts in WordPress?WordPressDynamically generate names in SCSS (animation example)SCSSHow to create a Random Hex Color generator using JavaScript?JavaScriptINNER JOIN in PostgresPostgres