...

View Full Version : Querying and Foreign Keys



subhailc
02-26-2009, 12:21 AM
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

Fou-Lu
02-26-2009, 02:54 AM
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.

subhailc
02-26-2009, 04:51 PM
Thank you.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum