The "root" of my problem is the assignment itself. It specifically states to use GROUP BY statements to accomplish the scenarios which in turn has me TOTALLY confused!! ...

Drop table Employees;

Drop table Job;

CREATE TABLE Job (

EEO_Classification VARCHAR(60) NOT NULL, ...

I think I figured this one out!!

Select Last_name,Salary,EE01_Classification

FROM Employees

WHERE Salary IN (SELECT Salary

FROM Employees

GROUP BY EE01_Classification,Salary)

ORDER BY EE01_Classification;

It seems to work....

Now on to the next one...GROUP BY with multiple tables...uggghhhhhh

Thanks...

I thought that too but I am taking a SQL Server class and the assignment specifically says to:

Write a SQL query that uses UNION of the two...

Sorry about that...it's not erroring out..it's only printing out the last_name and not giving me the job description from the job title. I suspect something to do with the...

You've got to be kidding me!!! I've gone over this thing with a magnifying glass and it was something that simple.....

Thanks man, I appreciate it!!

Michael