In PostgreSQL the INNER JOIN keyword selects all rows from both the tables as long as the condition satisfies. This keyword will create the result-set… Read More
Tag Archives: postgreSQL-joins
The PostgreSQL LEFT JOIN returns all the rows of the table on the left side of the join and matching rows for the table on… Read More
PostgreSQL has a special type of join called the SELF JOIN which is used to join a table with itself. It comes in handy when… Read More
A PostgreSQL Join statement is used to combine data or rows from one(self-join) or more tables based on a common field between them. These common… Read More
The PostgreSQL FULL OUTER JOIN or FULL JOIN creates the result-set by combining the result of both LEFT JOIN and RIGHT JOIN. The result-set will… Read More