moagrius Posted February 26, 2009 Share Posted February 26, 2009 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 More sharing options...
Mchl Posted February 26, 2009 Share Posted February 26, 2009 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 Link to comment https://forums.phpfreaks.com/topic/146960-querying-and-foreign-keys/#findComment-772101 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.