Test Your Microsoft SQL Server INNER JOIN Knowledge with This Quiz

Progress

True / False

Does the INNER JOIN keyword only return rows when there is a match in both tables?

True False

INNER JOIN returns rows when there is at least one match in both tables.

True / False

Can an INNER JOIN be used to join more than two tables?

True False

INNER JOIN can be used to join multiple tables in a single query.

True / False

Is it mandatory to have a common column between tables for an INNER JOIN?

True False

INNER JOIN requires a common column between the tables to join them.

True / False

Does the INNER JOIN keyword return unmatched rows from both tables?

True False

INNER JOIN does not return unmatched rows from both tables; it only returns matched rows.

True / False

Can INNER JOIN result in a Cartesian product if there is no ON clause?

True False

Without an ON clause, INNER JOIN can result in a Cartesian product.

True / False

Does an INNER JOIN automatically eliminate duplicate rows?

True False

INNER JOIN does not automatically eliminate duplicate rows.

True / False

Is it possible to use a WHERE clause along with an INNER JOIN?

True False

A WHERE clause can be used to filter the results of an INNER JOIN.

True / False

Can you join tables using an INNER JOIN based on a non-primary key column?

True False

INNER JOIN can be based on any column, not necessarily a primary key.

True / False

Does INNER JOIN return null values from columns of joined tables?

True False

INNER JOIN does not return rows with null values in the joined columns.

Q10

True / False

Can INNER JOIN be used with aliases for table names?

True False

Table aliases can be used to simplify queries with INNER JOIN.

Q11

True / False

Does the INNER JOIN keyword support joining tables from different databases?

True False

INNER JOIN can be used to join tables from different databases if the database system supports it.

Q12

True / False

Is the order of tables in an INNER JOIN clause important for the result set?

True False

The order of tables in INNER JOIN does not affect the result set.

Q13

True / False

Can INNER JOIN be used with aggregate functions?

True False

INNER JOIN can be combined with aggregate functions to produce grouped results.

Q14

True / False

Is it possible to use INNER JOIN in a subquery?

True False

INNER JOIN can be used within a subquery.

Q15

True / False

Does an INNER JOIN create a temporary table with combined results?

True False

INNER JOIN does not create a temporary table but combines results in the output.

Q16

Single Choice

Which clause is necessary to specify the condition for an INNER JOIN?

WHERE ON USINGHAVING

The ON clause specifies the condition for the INNER JOIN.

Q17

Single Choice

Which of the following queries correctly joins the Employees and Departments tables using INNER JOIN?

SQL Code

SELECT Employees.Name, Departments.DepartmentName
FROM Employees
INNER JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID;

SELECT Employees.Name, Departments.DepartmentName FROM Employees INNER JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID; SELECT Employees.Name, Departments.DepartmentName FROM Employees INNER JOIN Departments WHERE Employees.DepartmentID = Departments.DepartmentID; SELECT Employees.Name, Departments.DepartmentName FROM Employees INNER JOIN Departments USING (DepartmentID);SELECT Employees.Name, Departments.DepartmentName FROM Employees INNER JOIN Departments HAVING Employees.DepartmentID = Departments.DepartmentID;

The query correctly uses INNER JOIN to match rows based on DepartmentID.

Q18

Single Choice

How do you perform an INNER JOIN to get all employees with their respective manager names?

SQL Code

SELECT e.Name AS EmployeeName, m.Name AS ManagerName
FROM Employees e
INNER JOIN Employees m
ON e.ManagerID = m.EmployeeID;

SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m ON e.ManagerID = m.EmployeeID; SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Managers m ON e.ManagerID = m.ManagerID; SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m USING (ManagerID);SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Managers m HAVING e.ManagerID = m.ManagerID;

The query joins the Employees table with itself using INNER JOIN to match employees with their managers.

Q19

Single Choice

Which query shows an INNER JOIN between Orders and Customers to get customer names and their order dates?

SQL Code

SELECT Customers.CustomerName, Orders.OrderDate
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;

SELECT Customers.CustomerName, Orders.OrderDate FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderDate FROM Customers INNER JOIN Orders WHERE Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderDate FROM Customers INNER JOIN Orders USING (CustomerID);SELECT Customers.CustomerName, Orders.OrderDate FROM Customers INNER JOIN Orders HAVING Customers.CustomerID = Orders.CustomerID;

The query uses INNER JOIN to match rows based on CustomerID to get customer names and their order dates.

Q20

Single Choice

What does the INNER JOIN clause do in the following query: SELECT * FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID?

SQL Code

SELECT *
FROM Products
INNER JOIN Suppliers
ON Products.SupplierID = Suppliers.SupplierID;

It returns all rows from Products and Suppliers regardless of match. It returns rows from Products that have a matching SupplierID in Suppliers. It returns rows from Suppliers that have a matching ProductID in Products.It returns rows from Products and Suppliers based on a common column.

The INNER JOIN clause matches rows from Products and Suppliers based on SupplierID.

Q21

Single Choice

Which query correctly joins Customers and Orders to show all customer names with their respective order IDs?

SQL Code

SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;

SELECT Customers.CustomerName, Orders.OrderID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderID FROM Customers INNER JOIN Orders WHERE Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderID FROM Customers INNER JOIN Orders USING (CustomerID);SELECT Customers.CustomerName, Orders.OrderID FROM Customers INNER JOIN Orders HAVING Customers.CustomerID = Orders.CustomerID;

The query correctly joins Customers and Orders using INNER JOIN to show customer names with their order IDs.

Q22

Single Choice

Which clause is used to combine rows from two or more tables based on a related column?

WHERE ON INNER JOINHAVING

The INNER JOIN clause is used to combine rows from tables based on a related column.

Q23

Single Choice

What is the result of an INNER JOIN if no matching rows are found between the tables?

Returns unmatched rows from the left table Returns unmatched rows from the right table Returns unmatched rows from both tablesReturns an empty result set

If no matching rows are found, INNER JOIN returns an empty result set.

Q24

Single Choice

Which of the following SQL keywords is used to retrieve unique rows from multiple tables?

DISTINCT UNION INNER JOINGROUP BY

The INNER JOIN keyword is used to retrieve unique rows from multiple tables based on a match.

Q25

Single Choice

What is the purpose of the ON clause in an INNER JOIN statement?

To filter rows after joining To specify the join condition To group the result setTo sort the result set

The ON clause specifies the condition for joining the tables in an INNER JOIN statement.

Q26

Single Choice

Which SQL function can be used in combination with INNER JOIN to count the number of rows?

SUM COUNT AVGMIN

The COUNT function can be used to count the number of rows returned by an INNER JOIN.

Q27

Single Choice

Which clause should be used to join tables and include only those rows with matching values?

LEFT JOIN RIGHT JOIN FULL JOININNER JOIN

The INNER JOIN clause includes only those rows with matching values in both tables.

Q28

Single Choice

Which query retrieves the names of employees and their department names using INNER JOIN?

SQL Code

SELECT Employees.Name, Departments.DepartmentName
FROM Employees
INNER JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID;

The query uses INNER JOIN to retrieve employee names and their department names.

Q29

Single Choice

Which of the following queries correctly retrieves customer names and their order dates?

SQL Code

SELECT Customers.CustomerName, Orders.OrderDate
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;

The query retrieves customer names and their order dates using INNER JOIN.

Q30

Single Choice

Which keyword should be used to join tables and return only matching rows from both tables?

LEFT JOIN RIGHT JOIN FULL JOININNER JOIN

The INNER JOIN keyword is used to join tables and return only matching rows from both tables.

Q31

Multiple Choice

Which query retrieves all products with their supplier names using INNER JOIN?

SQL Code

SELECT Products.ProductName, Suppliers.SupplierName
FROM Products
INNER JOIN Suppliers
ON Products.SupplierID = Suppliers.SupplierID;

SELECT Products.ProductName, Suppliers.SupplierName FROM Products INNER JOIN Suppliers ON Products.SupplierID = Suppliers.SupplierID; SELECT Products.ProductName, Suppliers.SupplierName FROM Products INNER JOIN Suppliers WHERE Products.SupplierID = Suppliers.SupplierID; SELECT Products.ProductName, Suppliers.SupplierName FROM Products INNER JOIN Suppliers USING (SupplierID);SELECT Products.ProductName, Suppliers.SupplierName FROM Products INNER JOIN Suppliers HAVING Products.SupplierID = Suppliers.SupplierID;

The query retrieves all products with their supplier names using INNER JOIN based on SupplierID.

Q32

Multiple Choice

Which of the following queries correctly retrieves employees' names and their managers' names?

SQL Code

SELECT e.Name AS EmployeeName, m.Name AS ManagerName
FROM Employees e
INNER JOIN Employees m
ON e.ManagerID = m.EmployeeID;

SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m ON e.ManagerID = m.EmployeeID; SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m WHERE e.ManagerID = m.EmployeeID; SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m USING (ManagerID);SELECT e.Name AS EmployeeName, m.Name AS ManagerName FROM Employees e INNER JOIN Employees m HAVING e.ManagerID = m.EmployeeID;

The query correctly joins the Employees table with itself using INNER JOIN to match employees with their managers.

Q33

Multiple Choice

Which query retrieves customer names and their order dates using INNER JOIN?

SQL Code

SELECT Customers.CustomerName, Orders.OrderDate
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;

The query retrieves customer names and their order dates using INNER JOIN.

Q34

Multiple Choice

Which query retrieves department names and their manager names using INNER JOIN?

SQL Code

SELECT Departments.DepartmentName, Employees.Name AS ManagerName
FROM Departments
INNER JOIN Employees
ON Departments.ManagerID = Employees.EmployeeID;

SELECT Departments.DepartmentName, Employees.Name AS ManagerName FROM Departments INNER JOIN Employees ON Departments.ManagerID = Employees.EmployeeID; SELECT Departments.DepartmentName, Employees.Name AS ManagerName FROM Departments INNER JOIN Employees WHERE Departments.ManagerID = Employees.EmployeeID; SELECT Departments.DepartmentName, Employees.Name AS ManagerName FROM Departments INNER JOIN Employees USING (ManagerID);SELECT Departments.DepartmentName, Employees.Name AS ManagerName FROM Departments INNER JOIN Employees HAVING Departments.ManagerID = Employees.EmployeeID;

The query retrieves department names and their manager names using INNER JOIN based on ManagerID.

Q35

Multiple Choice

Which query shows an INNER JOIN between Customers and Orders to get customer names and their order amounts?

SQL Code

SELECT Customers.CustomerName, Orders.OrderAmount
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;

SELECT Customers.CustomerName, Orders.OrderAmount FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderAmount FROM Customers INNER JOIN Orders WHERE Customers.CustomerID = Orders.CustomerID; SELECT Customers.CustomerName, Orders.OrderAmount FROM Customers INNER JOIN Orders USING (CustomerID);SELECT Customers.CustomerName, Orders.OrderAmount FROM Customers INNER JOIN Orders HAVING Customers.CustomerID = Orders.CustomerID;

The query uses INNER JOIN to match rows based on CustomerID to get customer names and their order amounts.

Q36

Multiple Choice

Which query retrieves all orders with their product names using INNER JOIN?

SQL Code

SELECT Orders.OrderID, Products.ProductName
FROM Orders
INNER JOIN OrderDetails
ON Orders.OrderID = OrderDetails.OrderID
INNER JOIN Products
ON OrderDetails.ProductID = Products.ProductID;

SELECT Orders.OrderID, Products.ProductName FROM Orders INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID; SELECT Orders.OrderID, Products.ProductName FROM Orders INNER JOIN OrderDetails WHERE Orders.OrderID = OrderDetails.OrderID INNER JOIN Products USING (ProductID); SELECT Orders.OrderID, Products.ProductName FROM Orders INNER JOIN OrderDetails USING (OrderID) INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID;SELECT Orders.OrderID, Products.ProductName FROM Orders INNER JOIN OrderDetails HAVING Orders.OrderID = OrderDetails.OrderID INNER JOIN Products USING (ProductID);

The query retrieves all orders with their product names using INNER JOIN to match OrderID and ProductID.

Q37

Multiple Choice

Which query retrieves employee names and their project names using INNER JOIN?

SQL Code

SELECT Employees.Name AS EmployeeName, Projects.ProjectName
FROM Employees
INNER JOIN EmployeeProjects
ON Employees.EmployeeID = EmployeeProjects.EmployeeID
INNER JOIN Projects
ON EmployeeProjects.ProjectID = Projects.ProjectID;

SELECT Employees.Name AS EmployeeName, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects ON Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects ON EmployeeProjects.ProjectID = Projects.ProjectID; SELECT Employees.Name AS EmployeeName, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects WHERE Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects USING (ProjectID); SELECT Employees.Name AS EmployeeName, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects USING (EmployeeID) INNER JOIN Projects ON EmployeeProjects.ProjectID = Projects.ProjectID;SELECT Employees.Name AS EmployeeName, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects HAVING Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects USING (ProjectID);

The query retrieves employee names and their project names using INNER JOIN to match EmployeeID and ProjectID.

Q38

Multiple Choice

Which query retrieves department names and the number of employees in each department using INNER JOIN?

SQL Code

SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees
FROM Departments
INNER JOIN Employees
ON Departments.DepartmentID = Employees.DepartmentID
GROUP BY Departments.DepartmentName;

SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees FROM Departments INNER JOIN Employees ON Departments.DepartmentID = Employees.DepartmentID GROUP BY Departments.DepartmentName; SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees FROM Departments INNER JOIN Employees WHERE Departments.DepartmentID = Employees.DepartmentID GROUP BY Departments.DepartmentName; SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees FROM Departments INNER JOIN Employees USING (DepartmentID) GROUP BY Departments.DepartmentName;SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees FROM Departments INNER JOIN Employees HAVING Departments.DepartmentID = Employees.DepartmentID GROUP BY Departments.DepartmentName;

The query retrieves department names and the number of employees in each department using INNER JOIN and GROUP BY.

Q39

Multiple Choice

Which query retrieves all orders with their customer names and product names using INNER JOIN?

SQL Code

SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName
FROM Orders
INNER JOIN Customers
ON Orders.CustomerID = Customers.CustomerID
INNER JOIN OrderDetails
ON Orders.OrderID = OrderDetails.OrderID
INNER JOIN Products
ON OrderDetails.ProductID = Products.ProductID;

SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID; SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName FROM Orders INNER JOIN Customers WHERE Orders.CustomerID = Customers.CustomerID INNER JOIN OrderDetails USING (OrderID) INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID; SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName FROM Orders INNER JOIN Customers USING (CustomerID) INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID;SELECT Orders.OrderID, Customers.CustomerName, Products.ProductName FROM Orders INNER JOIN Customers HAVING Orders.CustomerID = Customers.CustomerID INNER JOIN OrderDetails USING (OrderID) INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID;

The query retrieves all orders with their customer names and product names using INNER JOIN to match CustomerID, OrderID, and ProductID.

Q40

Multiple Choice

Which query retrieves project names and their start dates using INNER JOIN?

SQL Code

SELECT Projects.ProjectName, Projects.StartDate
FROM Projects
INNER JOIN ProjectDetails
ON Projects.ProjectID = ProjectDetails.ProjectID;

SELECT Projects.ProjectName, Projects.StartDate FROM Projects INNER JOIN ProjectDetails ON Projects.ProjectID = ProjectDetails.ProjectID; SELECT Projects.ProjectName, Projects.StartDate FROM Projects INNER JOIN ProjectDetails WHERE Projects.ProjectID = ProjectDetails.ProjectID; SELECT Projects.ProjectName, Projects.StartDate FROM Projects INNER JOIN ProjectDetails USING (ProjectID);SELECT Projects.ProjectName, Projects.StartDate FROM Projects INNER JOIN ProjectDetails HAVING Projects.ProjectID = ProjectDetails.ProjectID;

The query retrieves project names and their start dates using INNER JOIN based on ProjectID.

Q41

Multiple Choice

Which query retrieves the names of employees and their project names using INNER JOIN?

SQL Code

SELECT Employees.Name, Projects.ProjectName
FROM Employees
INNER JOIN EmployeeProjects
ON Employees.EmployeeID = EmployeeProjects.EmployeeID
INNER JOIN Projects
ON EmployeeProjects.ProjectID = Projects.ProjectID;

SELECT Employees.Name, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects ON Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects ON EmployeeProjects.ProjectID = Projects.ProjectID; SELECT Employees.Name, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects WHERE Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects USING (ProjectID); SELECT Employees.Name, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects USING (EmployeeID) INNER JOIN Projects ON EmployeeProjects.ProjectID = Projects.ProjectID;SELECT Employees.Name, Projects.ProjectName FROM Employees INNER JOIN EmployeeProjects HAVING Employees.EmployeeID = EmployeeProjects.EmployeeID INNER JOIN Projects USING (ProjectID);

The query retrieves the names of employees and their project names using INNER JOIN.

Q42

Multiple Choice

Which query retrieves the names of departments and the number of employees in each department using INNER JOIN?

SQL Code

SELECT Departments.DepartmentName, COUNT(Employees.EmployeeID) AS NumberOfEmployees
FROM Departments
INNER JOIN Employees
ON Departments.DepartmentID = Employees.DepartmentID
GROUP BY Departments.DepartmentName;

The query retrieves the names of departments and the number of employees in each department using INNER JOIN and GROUP BY.

Q43

Multiple Choice

Which query retrieves the names of customers and the total amount of their orders using INNER JOIN?

SQL Code

SELECT Customers.CustomerName, SUM(Orders.OrderAmount) AS TotalAmount
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
GROUP BY Customers.CustomerName;

SELECT Customers.CustomerName, SUM(Orders.OrderAmount) AS TotalAmount FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerName; SELECT Customers.CustomerName, SUM(Orders.OrderAmount) AS TotalAmount FROM Customers INNER JOIN Orders WHERE Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerName; SELECT Customers.CustomerName, SUM(Orders.OrderAmount) AS TotalAmount FROM Customers INNER JOIN Orders USING (CustomerID) GROUP BY Customers.CustomerName;SELECT Customers.CustomerName, SUM(Orders.OrderAmount) AS TotalAmount FROM Customers INNER JOIN Orders HAVING Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerName;

The query retrieves the names of customers and the total amount of their orders using INNER JOIN and GROUP BY.

Q44

Multiple Choice

Which query retrieves the names of suppliers and the number of products they supply using INNER JOIN?

SQL Code

SELECT Suppliers.SupplierName, COUNT(Products.ProductID) AS NumberOfProducts
FROM Suppliers
INNER JOIN Products
ON Suppliers.SupplierID = Products.SupplierID
GROUP BY Suppliers.SupplierName;

SELECT Suppliers.SupplierName, COUNT(Products.ProductID) AS NumberOfProducts FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID GROUP BY Suppliers.SupplierName; SELECT Suppliers.SupplierName, COUNT(Products.ProductID) AS NumberOfProducts FROM Suppliers INNER JOIN Products WHERE Suppliers.SupplierID = Products.SupplierID GROUP BY Suppliers.SupplierName; SELECT Suppliers.SupplierName, COUNT(Products.ProductID) AS NumberOfProducts FROM Suppliers INNER JOIN Products USING (SupplierID) GROUP BY Suppliers.SupplierName;SELECT Suppliers.SupplierName, COUNT(Products.ProductID) AS NumberOfProducts FROM Suppliers INNER JOIN Products HAVING Suppliers.SupplierID = Products.SupplierID GROUP BY Suppliers.SupplierName;

The query retrieves the names of suppliers and the number of products they supply using INNER JOIN and GROUP BY.

Q45

Multiple Choice

Which query retrieves the names of employees and their salaries using INNER JOIN?

SQL Code

SELECT Employees.Name, Salaries.Salary
FROM Employees
INNER JOIN Salaries
ON Employees.EmployeeID = Salaries.EmployeeID;

SELECT Employees.Name, Salaries.Salary FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID; SELECT Employees.Name, Salaries.Salary FROM Employees INNER JOIN Salaries WHERE Employees.EmployeeID = Salaries.EmployeeID; SELECT Employees.Name, Salaries.Salary FROM Employees INNER JOIN Salaries USING (EmployeeID);SELECT Employees.Name, Salaries.Salary FROM Employees INNER JOIN Salaries HAVING Employees.EmployeeID = Salaries.EmployeeID;

The query retrieves the names of employees and their salaries using INNER JOIN based on EmployeeID.

Microsoft SQL Server Database Quiz Questions