Jump to content

Querying and Foreign Keys


moagrius

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/146960-querying-and-foreign-keys/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.