Inner Join

Join Tables, Selecting All Columns

SELECT *

FROM SQL_Data_File_Movies

INNER JOIN [SQL_Data_File_Company-Info]

ON SQL_Data_File_Movies.Platform = [SQL_Data_File_Company-Info].Platform;

Join Tables, Selecting Specific Columns

SELECT

SQL_Data_File_Movies.Title,

SQL_Data_File_Movies.Year,

SQL_Data_File_Movies.MPAA_Rating,

[SQL_Data_File_Company-Info].Platform,

[SQL_Data_File_Company-Info].Phone

FROM SQL_Data_File_Movies

INNER JOIN [SQL_Data_File_Company-Info]

ON SQL_Data_File_Movies.Platform = [SQL_Data_File_Company-Info].Platform;

Join Tables, Selecting Specific Columns, With WHERE Clause

SELECT

SQL_Data_File_Movies.Title,

SQL_Data_File_Movies.Year,

SQL_Data_File_Movies.MPAA_Rating,

[SQL_Data_File_Company-Info].Platform,

[SQL_Data_File_Company-Info].Phone

FROM SQL_Data_File_Movies

INNER JOIN [SQL_Data_File_Company-Info]

ON SQL_Data_File_Movies.Platform = [SQL_Data_File_Company-Info].Platform

WHERE

(((SQL_Data_File_Movies.Year)>=2017)

AND (([SQL_Data_File_Company-Info].Platform)="Netflix"))

OR

(((SQL_Data_File_Movies.Year)=2012)

AND (([SQL_Data_File_Company-Info].Platform)="Netflix"));