Tagged: sql

sql-right join 0

SQL RIGHT JOIN Keyword

It will take approximately 3 minutes to read this article. The SQL RIGHT JOIN returns all rows from the right table, even if there are no matches in the left table. This means that if the...






sql-left-join 0

SQL LEFT JOIN Keyword

It will take approximately 3 minutes to read this article. The SQL LEFT JOIN (specified with the keywords LEFT JOIN and ON) joins two tables and fetches all matching rows of two tables. This join returns...






sql-language 0

SQL INNER JOIN Keyword

It will take approximately 3 minutes to read this article. INNER JOIN is one of the most important and frequently used of the JOINS. Also, INNER JOIN can be referred as EQUIJOIN in some...