469,319 Members | 1,911 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

joins syntax

What’s wrong with the statement:
SELECT employees.Last_name, employees.First_name, departments.Department_id
FROM employees emp inner join departments
on (employees.Department_id = Departments.Department_id)
order by 3;
Apr 21 '07 #1
1 975
temat
5
U didnt use an ALIAS "employees as emp "
[PHP]
SELECT
emp.Last_name,
emp.First_name,
departments.Department_id
FROM
employees as emp
inner join departments
on (emp.Department_id = Departments.Department_id)
ORDER BY 3;
[/PHP]

I gues it wos the problem.
Apr 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ralph Freshour | last post: by
1 post views Thread by Joshua Goodstein | last post: by
3 posts views Thread by Prem | last post: by
2 posts views Thread by raulgz | last post: by
1 post views Thread by deepak.rao | last post: by
1 post views Thread by yaroni | last post: by
3 posts views Thread by jakelake | last post: by
4 posts views Thread by michaelnewport | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.