Querying and Foreign Keys

Hi,

Say I've got 2 Tables: Supervisors and Employees

Supervisors might look something like this:

ID Dept_ID FName LName
1 1 Bob Smith
2 1 John Doe
3 1 Ken Jones
4 2 Sam West
5 2 Jim Brown

And Employees might look like this:

ID Super_ID FName LName
1 5 John Adams
2 3 George Washington
3 4 Thomas Jefferson
4 2 Abe Lincoln
5 5 Ron Reagon
6 1 John Kennedy
7 1 Linden Johnson
8 3 James Carter
9 2 George Bush
10 3 Richard Nixon

How would I structure a query that selected all employees whose supervisor had a Dept_ID of 1?

TYIA

SELECT e.ID, e.FName, e.LName FROM `Employees` e
INNER JOIN `Supervisors` s ON (s.ID = e.Super_ID)
WHERE s.Dept_ID = 1

I assume that Super_ID is the supervisor's ID.

Thank you.