SQL Tutorial - 31: Left Outer JOIN

Показать описание

In this tutorial we'll take a look at the LEFT Outer JOIN and see how it is different from the regular JOIN

Рекомендации по теме

Комментарии

You tutorial is great! Nice and short. However, if you can put a picture of the table you are talking about, on the side of the video at all times, it would be even more helpful!

SahitiSeemakurti

Si el título dice left outer join, porque no usaste eso ??

davidbailon

USE test;

DESC tutorial;

INSERT INTO tutorial (id, title, subject, duration, upload_date)
VALUES
(18, 'Excel Tutorial-1', 'Microsoft Excel', 3.86, '2013-12-11'),
(19, 'Excel Tutorial-2', 'Microsoft Excel', 4.06, '2013-12-11'),
(20, 'Excel Tutorial-3', 'Microsoft Excel', 7.03, '2013-12-11'),
(21, 'Excel Tutorial-4', 'Microsoft Excel', 5.63, '2013-12-11'),
(22, 'Excel Tutorial-5', 'Microsoft Excel', 6.17, '2013-12-11');

SELECT * FROM tutorial;

SELECT * FROM tutorial_info;

INSERT INTO tutorial_info (tutorial_id, views, likes, dislikes, shares)
VALUES
(7, 85000, 106, 25, 8),
(8, 91000, 166, 24, 17),
(9, 191000, 846, 48, 32),
(10, 235000, 1170, 93, 52),
(11, 454000, 2070, 117, 63),
(12, 51500, 2900, 131, 96),
(13, 644000, 3280, 137, 12),
(14, 644000, 3280, 137, 12),
(15, 329000, 1115, 143, 7),
(16, 147589, 650, 22, 3),

(23, 45000, 650, 131, 11),
(24, 57850, 784, 146, 17),
(25, 313000, 1185, 163, 19);

PabloMoricz

SQL Tutorial - 31: Left Outer JOIN

SQL Tutorial - 31: Left Outer JOIN

Let's Learn SQL! Lesson 31 : The Left Outer Join

SQL Subquery using EXISTS and IN - SQL Tutorial #31

SQL LEFT JOIN - SQL Tutorial #23

SQL Tutorial 31 | Table Variable,Temp Table | Tamil

35 - SQL LEFT() Function - Learn SQL from www.SQLServerLog.com [HD]

SQL Tutorial #31 - SQL Join | SQL Inner Join | SQL Joins Tutorial

SQL Inner, Left, and Right Joins - MySQL Tutorial #5

COMPLETE SQL COURSE in 7 HOURS - FROM ZERO TO HERO (SQL SERVER)

Working with Multiple Tables in SQL Tutorial | Python Soldiers #shorts #sql #tutorial #python

SQL Server LEFT JOINS Explained (with simple examples)

Full Outer Join: SQL Tutorial with Example

SQL Tutorial for Data Analysis 31: Introduction to Sub Queries

SQL Trick | How many times does a character occur in a string?

SQL Tutorial - Full Database Course for Beginners

SQL tutorial 31 : SQL Cross Join In Oracle Database By Manish Sharma from RebellionRider

SQL Left Outer Join Master Class | SQL Advance Tutorial Zero to Hero

SQL Tricks | How to Extract String After the Last Occurrence of Delimiter ? REVERSE

Oracle SQL Video Tutorial 31 - HAVING Clause

Case Conversion Functions: SQL Tutorial 31

SQL Joins: A Guide and Examples

SQL Left Join | Left outer join in SQL

SQL | Count(*) vs Count(1) Vs Count(colname) #sqltips

SQL Left Outer Join - SQL Training Online - Quick Tips Ep24