SQL | LEFT (OUTER) JOIN and RIGHT (OUTER) JOIN in SQL | Combine rows from multiple tables | SQL join

Описание к видео SQL | LEFT (OUTER) JOIN and RIGHT (OUTER) JOIN in SQL | Combine rows from multiple tables | SQL join

In this video we see how to join two tables using left (outer) join and right (outer) join in SQL.

JOIN clause is used to combine rows from two or more tables, based on a related column. Joins can be equi-joins and non equi-joins.

LEFT (OUTER) JOIN: Returns all records from the left table, and the matched (common) records from the right table.

RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched (common) records from the left table.

"Thanks for watching. If you liked this video, make sure to subscribe for more!”

#dataprojecthub
#data_project_hub

Комментарии

Информация по комментариям в разработке

Похожие видео