Q.Using the Employee and Dept tables, write an SQL query (an equi-join) to display each employee's name, their department, and the city in which that department is located.

This asks you to join two related tables on their shared column to combine data from both.

The employee's name and department come from the Employee table, while the department's city comes from the Dept table. To combine them we perform an equi-join on the shared value: Employee.Dept must equal Dept.DeptName.

SELECT Employee.Name, Employee.Dept, Dept.City
FROM Employee, Dept
WHERE Employee.Dept = Dept.DeptName;

This produces one row per employee, each matched to the correct city — for example:

The modern, clearer style uses JOIN ... ON with aliases: SELECT E.Name, E.Dept, D.City FROM Employee AS E JOIN Dept AS D ON E.Dept = D.DeptName; — …

Forgetting the join condition (the WHERE ... = ... part) turns the query into a cartesian product with many wrong rows. When a column name exists in both tables, qualify it …