Join Archives

How To Use CROSS JOIN Keyword In SQL

Yasin Panwala Nov 18, 2019 0 548

In this article, we will learn how to use the CROSS JOIN keyword in SQL.

The CROSS JOIN keyword is used to combine each row of the first table with each row from the second table, also known as CARTESIAN JOIN.

In general words, we can say that the CROSS JOIN keyword is used to select the Cartesian product of the sets of rows from the joined table.

How To Use FULL OUTER JOIN Keyword In SQL

Yasin Panwala Nov 16, 2019 0 695

In this article, we will learn how to use the FULL OUTER JOIN keyword in SQL. The FULL OUTER JOIN is also known as FULL JOIN.

The FULL OUTER JOIN keyword is used to select all records from both tables.

The columns of the left table will have nulls when no matching rows exist for the row in the right table. Similarly, The columns of the right table will have nulls when no matching rows exist for the row in the left table.

How To Use RIGHT JOIN Keyword In SQL

Yasin Panwala Nov 16, 2019 0 610

In this article, we will learn how to use the RIGHT JOIN keyword in SQL.

The RIGHT JOIN keyword is used to select all records from the table2 (right table), and the matched records from the table1 (left table). If there is no match, the result from the left side is NULL.

How To Use LEFT JOIN Keyword In SQL

Yasin Panwala Nov 11, 2019 0 705

In this article, we will learn how to use the LEFT JOIN keyword in SQL.

The LEFT JOIN keyword is used to select all records from the table1 (left table), and the matched records from the table2 (right table). If there is no match, the result from the right side is NULL.

How To Use INNER JOIN Keyword In SQL

Yasin Panwala Nov 11, 2019 0 678

In this article, we will learn how to use the INNER JOIN Keyword in SQL.

The INNER JOIN keyword is used to select records that have matching values in both tables.

The INNER JOIN keyword selects all rows from both tables until there is a match between the columns.

Subscribe