Subquery Madness!

by Jonathan Gennick

If you write SQL, you might be interested in a recent article that I wrote about a subtle issue involving the merging of subqueries in the FROM clause of a SQL statement:

Subquery Madness!

Chris Date found the issue interesting, and was kind enough to write a response:

A Cure for Madness

Chris's article is enlightening and well worth a read.


2006-05-02 08:17:47
select lname,fname from employee where e_no in(select e_no from works_on where p_no=(select * from project))