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:
Chris Date found the issue interesting, and was kind enough to write a response:
Chris’s article is enlightening and well worth a read.
Contact Us | Advertise with Us | Privacy Policy | Press Center | Jobs
Weblog authors are solely responsible for the content and accuracy of their weblogs, including opinions they express,
and O’Reilly Media, Inc., disclaims any and all liability for that content, its accuracy, and opinions it may contain.
This work is licensed under a Creative Commons License.
For problems or assistance with this site, email help@oreillynet.com | (707) 827-7000 / (800) 998-9938
select lname,fname from employee where e_no in(select e_no from works_on where p_no=(select * from project))