Homework problem (dont understand what is being asked)

[acdougla17]

So I am doing a homework assignment where we need to write SQL queries using the "plain english" explanations given. There is one problem that I just cant make sense of what it is asking.

Display all the columns in Title for those that dont have any rows in Employee.


Title contains the columns code, name, min_salary, max_salary


Employee contains id, dcode, tcode, ssn, last_name, first_name, middle_init, hire, salary
I am pretty sure Title.code and Employee.tcode are the 2 being used.

My attempt at this (even though I dont know what the output is even supposed to be) is...

SELECT DISTINCT Title.*
FROM Title, Employee
WHERE Title.code<>Employee.tcode;

[orange]

You may want to look at some samples at
http://www.techonthenet.com

There are some sql samples - here is one

http://www.techonthenet.com/access/queries/joins2.php

[June7]

I will make a guesstimate instructor wants you to determine which Title records have not been associated with a record in Employee. Assuming Title.code and Employee.tcode are related key fields, query the tables with a join. Try:
SELECT Title.code, Title.name, Title.min_salary, Title.max_salary, Employee.tcode
FROM Employee RIGHT JOIN Title ON Employee.tcode = Title.code
WHERE (((Employee.tcode) Is Null));

The second link given by Orange is a good guideline for this.