Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - How to Perform a Left/Right Join

The video tutorial explains the concepts of left and right joins in SQL using two tables: 'IDF name' and 'Contact Info'. It covers the syntax for performing these joins, highlighting the differences in how each join handles unmatched rows. The left join includes all rows from the left table and matching rows from the right, while the right join includes all rows from the right table and matching rows from the left. The tutorial also discusses common errors and how to avoid them when using these joins.

What are the two tables used in the video tutorial?

• Employee Info and Contact Details

• IDF name and Employee Details

• Employee Data and Contact List

• IDF name and Contact Info

What does a left join operation do?

• Includes only matching rows from both tables

• Includes all rows from both tables

• Includes all rows from the left table and matching rows from the right table

• Includes all rows from the right table and matching rows from the left table

Why might some last names be missing in the left join result?

• Because the query has a syntax error

• Because the last names are stored in a different table

• Because the IDs do not match between the two tables

• Because the last names are not included in the query

What is the main difference between a left join and a right join?

• Left join includes all rows, right join includes only matching rows

• Left join includes all rows from the right table, right join includes all rows from the left table

• Left join includes all rows from the left table, right join includes all rows from the right table

• Left join includes only matching rows, right join includes all rows

What happens to the first name in the right join result when IDs do not match?

• It is duplicated

• It is ignored

• It is displayed as a missing value

• It is replaced with a default value