Write a representation of the following in relational algebr
Write a representation of the following in relational algebra
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10
Write a representation of the following in relational algebra
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10
2. SELECT *FROM employees LEFT JOIN branches on branch = branch number WHERE employee_id = 10
Solution
select * from employees as e,branches as b where e.employee_id= b.branch and e.employee_id=10
