HOW IS THIS SQL NOT WORKING

Question

SELECT Employees.EmployeeID,EmployeePhone.EmployeeID

FROM Employees

InnerJoin EmployeePhone ON Employees.EmployeeID=EmployeePhone.EmployeeID;

Also if someone can answer how to specify what you want to distinct using the Distinct function That would be incredibly helpful!

Answer 1

Hi Terra!

Your SQL query is not working because you have a syntax error. On the third line you have "InnerJoin" when it should be "INNER JOIN" with the space included! Lmk if you have any other issues!

The DISTINCT keyword in SQL is used to identify unique results. So if we take your query from the first part and add DISTINCT:

SELECT DISTINCT Employees.EmployeeID

FROM Employees

INNER JOIN EmployeePhone ON Employees.EmployeeID=EmployeePhone.EmployeeID;

This would then result in only unique EmployeeIDs being displayed, any duplicates would be removed from the result set.