joins syntax

[sekitoleko]

What’s wrong with the statement:
SELECT employees.Last_ name, employees.First _name, departments.Dep artment_id
FROM employees emp inner join departments
on (employees.Depa rtment_id = Departments.Dep artment_id)
order by 3;

[temat]

U didnt use an ALIAS "employees as emp "
[PHP]
SELECT
emp.Last_name,
emp.First_name,
departments.Dep artment_id
FROM
employees as emp
inner join departments
on (emp.Department _id = Departments.Dep artment_id)
ORDER BY 3;
[/PHP]

I gues it wos the problem.