Querying and Foreign Keys

[moagrius]

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

[Mchl]

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