06 SQL JOIN – Multiple Table Query | Designing Database Solutions with Microsoft SQL Server 2019

In this video, Joed Goh demonstrates how to retrieve records from multiple related tables. Specifically, he compares the INNER JOIN and OUTER JOIN (LEFT join and RIGHT join).

Table of Contents:
00:00 Introduction
01:26 INNER Join
08:50 OUTER JOIN
12:14 Combining Inner Join and Outer Join
14:21 DISTINCT Clause

PLAYLISTS:
Designing Database Solutions with Microsoft SQL Server 2019
https://youtube.com/playlist?list=PLVTsfY7Kr9qjagmWoPLXPvdOk46C5IAB_

Android App Development in Kotlin
https://youtube.com/playlist?list=PLVTsfY7Kr9qimoaNmBCQQcvNi49EoKTWS

Embedded Systems using Arduino Uno
https://youtube.com/playlist?list=PLVTsfY7Kr9qhkfmq85MH2xObFIELuq_Vo

Data Structures and Algorithms using C#
https://youtube.com/playlist?list=PLVTsfY7Kr9qiTxECmzTVkLZt1DkaFEfUg