/* Query 1B (page 137,171,223 of the text book) 

   Retrieve the name and address of all employees
   who work for the 'Research' department.

   The result must be
	'John'	'Smith'	'731 Fondren, Houston, TX'
	'Franklin'	'Wong'	'638 Voss, Houston, TX'
	'Ramesh'	'Narayan'	'975 Fire Oak, Humble, TX'
	'Joyce'	'English'	'5631 Rice, Houston, TX'
*/

select	fname, lname, address
from	employee e, department d
where	d.dname = 'Research' and d.dnumber = e.dno;
