where clause demo code

where clause

SELECT e.employee_id, 
       d.location_id  
FROM   employees e,departments d  
WHERE  e.department_id = d.department_id AND
       e.last_name = 'Matos';