PostgreSQL Inner Join

This join is performed by giving an explicit join condition.PostgreSQL inner join is used to join data or records from two or more tables based on matching values ​​in both tables.The inner join will create the resulting set until the condition is satisfied by combining all rows from both tables.The join is taken on the primary key and the foreign key of the two tables.The row will not appear in the output if it does not satisfy the given join condition.
This join is also called as an equi join since and = operators is used to give the join condition

Inner Joins Syntax :

The syntax of the Inner Joins statement is −

SELECT col_name,...
FROM table_name1 t1  [INNER] JOIN table_name2 t2
ON t1.col_name = t2.col_name

PostgreSQL Inner Join Example :

Consider the Customer table with the following records -

Consider the Order table with the following records -

TEST CASE 1 :- Let us join these two tables using the INNER JOIN as follows

lfcdb=# SELECT  ID, Name, Amount, Date
FROM Customer
INNER JOIN Order
ON Customer.ID = Order.CustomerID;

The result for the respective PostgreSQL query is as follows −

---

Visit :

---

Discussion