Re: relational algebra - semi joins

> ok the answer to my question seems to be NO.
> SELECT Dept#, dept_name FROM Depts
> WHERE Depts.Dept# = Employees.Dept#;

Why not:

SELECT DISTINCT dept_no, dept_name
FROM depts, employees
WHERE depts.dept_no = employees.dept_no;

This is just a standard inner join, together with a projection onto the columns in the result. Received on Mon May 17 2004 - 09:00:47 CDT