Skip to content

Tag Archives: postgreSQL-joins

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
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