Mastering SQL JOIN and Inner Join

To combine rows from two or more tables based on a related column between them (correct)

To update rows from two or more tables based on a related column between them

To delete rows from two or more tables based on a related column between them

To insert rows into two or more tables based on a related column between them

The 'CustomerID' column in the 'Orders' table refers to the 'CustomerID' in the 'Customers' table (correct)

The 'CustomerID' column in the 'Orders' table and the 'CustomerID' column in the 'Customers' table are unrelated

The 'CustomerID' column in the 'Customers' table refers to the 'CustomerID' in the 'Orders' table

The 'CustomerID' column in the 'Orders' table and the 'CustomerID' column in the 'Customers' table are the same column

Excludes rows from the tables where the join conditions are satisfied

Returns all rows from both tables

Returns only the rows from the first table

Includes rows from the tables where the join conditions are satisfied (correct)