SQL Server INNER JOINs in 60 seconds
In this video, we'll have a look at how to connect two tables together in SQL Server using INNER JOINs.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
INNER JOINs enable you to retrieve the rows of two tables where the rows match. This is the default JOIN.
The code used in the video is:
DROP TABLE IF EXISTS table1;
DROP TABLE IF EXISTS table2;
CREATE TABLE table1
(Column1 int);
CREATE TABLE table2
(Column2 int);
INSERT INTO table1 VALUES
(3), (5), (6), (7), (8), (9), (16), (17), (18), (19);
INSERT INTO table2 VALUES
(16), (17), (18), (19), (20), (21), (22), (23), (24), (25), (27), (28), (29);
SELECT Column1
FROM table1
INNER JOIN table2
ON table1.Column1 = table2.Column2;
SELECT Column1
FROM table1 AS T1
INNER JOIN table2 AS T2
ON T1.Column1 = T2.Column2;
----
Links to my website are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: http://idodata.com/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): http://idodata.com/database-fundament...
SQL Server Essential in an Hour: http://idodata.com/sql-server-essenti...
70-462 SQL Server Database Administration (DBA): http://idodata.com/sql-server-databas...
DP-300: Administering Relational Databases: http://idodata.com/dp-300-administeri...
Microsoft SQL Server Reporting Services (SSRS): http://idodata.com/microsoft-sql-serv...
SQL Server Integration Services (SSIS): http://idodata.com/sql-server-integra...
SQL Server Analysis Services (SSAS): http://idodata.com/sql-server-ssas-mu...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
1Z0-071 Oracle SQL Developer – certified associate: http://idodata.com/iz0-071-oracle-sql...
SQL for Microsoft Access: http://idodata.com/sql-for-microsoft-...
DP-900: Microsoft Azure Data Fundamentals: http://idodata.com/dp-900-microsoft-a...
Смотрите видео SQL Server INNER JOINs in 60 seconds онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал SQL Server 101 11 Июль 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 540 раз и оно понравилось 29 посетителям.
