How to sort multiple columns in a multitable query?

Question

I have a question about how to find salary discrimination based on the employee gender. I have MS Acess 2007 and must use SQL queries to figure it out

Keep in mind, this is after I joined 3 tables together into one multi-table query. Within this query, whenever I want to sort any column with, for example, an ORDER BY Salary, it gives me an error sign saying:

Syntax error (missing operator) in query expression 'Salary'
WHERE JobClass.JobClassID = Employees.JobClassID 
AND Department.DepartmentID = Employees.DepartmentID'.

I want to try to sort more than one column within the query.

Here is the multitable query code in total:

SELECT JobClass.JobClassID, JobClassName, Department.DepartmentID, 
       DepartmentName, LastName, FirstName, Title, Sex, Years, Salary
FROM  JobClass, Employees, Department
ORDER BY 'Salary'
WHERE JobClass.JobClassID = Employees.JobClassID AND Department.DepartmentID = Employees.DepartmentID;

`order by` should be after `where` clause – G one Mar 05 '14 at 06:39 — G one, Mar 05 '14 at 06:39
and remove ' ' from the ORDER BY 'Salary' – The Hungry Dictator Mar 05 '14 at 06:52 — The Hungry Dictator, Mar 05 '14 at 06:52

score 1 · Answer 1 · answered Mar 05 '14 at 06:41

Order by Clause should be come after the where clause

Try like this

SELECT JobClass.JobClassID, JobClassName, Department.DepartmentID, 
       DepartmentName, LastName, FirstName, Title, Sex, Years, Salary
FROM  JobClass, Employees, Department
WHERE JobClass.JobClassID = Employees.JobClassID AND Department.DepartmentID = Employees.DepartmentID
ORDER BY Salary

SLECT SYNTAX

SELECT [predicate] { * | table.* | [table.]field1 [AS alias1] [, [table.]field2 [AS alias2] [, …]]}     
FROM tableexpression [, …] [IN externaldatabase]     
[WHERE… ]    
[GROUP BY… ]     
[HAVING… ]     
[ORDER BY… ]     
[WITH OWNERACCESS OPTION]

erik258 · Answer 2 · 2014-03-05T20:23:15.103

0

Unless Access '07 completely disregards standard SQL ( and I don't think it does) your SQL Syntax is off.

Instead of putting the ORDER BY before the WHERE clause, it should go after the WHERE.

edited Mar 05 '14 at 20:23

answered Mar 05 '14 at 06:36

erik258

14,701
2
25
31

Umm, there is no `WHILE` clause in SQL. – Yawar Mar 05 '14 at 13:11
oh, sorry, WHERE. Duh. – erik258 Mar 05 '14 at 20:23

How to sort multiple columns in a multitable query?

2 Answers2