Inner Joins- MySql

What is an InnerJoin??

• This Join returns all rows from the left table, and the matching rows from the right table.

• This Join creates a new table by combining rows that have matching values in two or more tables.

• This Join is a method of combining two or more tables so that the result includes unmatched rows of one of the tables, or of both tables

• This Join is similar to left joins except they return all rows from the table in the RIGHT clause and only matching rows from the table in the FROM clause.

Which of the following SQL commands performs an INNER JOIN?

• SELECT Column_list

  FROM TABLE1

  INNER JOIN TABLE2

  ON Table1.ColName = Table2.ColName

• SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition;

• SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

• SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

Which keyword is commonly used to perform an INNER JOIN in MYSQL?

• OUTER

• WHERE

• JOIN

• INNER

In a scenario where table A has 100 rows and table B has 80 rows, and there are 60 matching rows, how many rows will be returned by an inner join?

• 60

• 80

• 100

• 140

When using an INNER JOIN, what happens if there are no matching rows between the tables?

• The query returns an error

• The query returns all rows from both tables

• The query returns an empty result set

• The query returns only the rows from the left table

How Many Tables Can You Innner Join?

• As many as you want, as long as thier records have matching values.

• Only two

• It depends

• Don't Know

Select the appropriate command to create a new table with columns Item name, Item unit, company name, and company city. The inner join is based on the company IDs from both tables.

• SELECT foods.item_name,foods.item_unit,

  company.company_name,company.company_city

  FROM foods

  INNER JOIN company

  ON foods.company_id =company.company_id;

• SELECT foods.company-id,foods.item_unit,

  company.company_id,company.company_city

  FROM foods

  INNER JOIN company

  ON foods.company_id =company.company_id;

• SELECT foods.item_name, company.item_unit, company.company_name, foods.company_city FROM foods INNER JOIN company ON foods.company_id = company.company_id;

• SELECT foods.item_name, company.item_unit, company.company_name, foods.company_city FROM foods INNER JOIN company ON foods.company_id = company.company_id;