JOINS
Whole point of relational database
To get info from several tables in one qry
E.FNm, E.LNm, E.Phone, D.DeptNm
Join Condition—which rows to connect FROM Dept D, Emp E WHERE D.DeptID = E.DeptID
Can apply additional criteria as needed: AND DeptCity = ‘Boston’