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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/146960-querying-and-foreign-keys/#findComment-772101 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.