SQL Subselect: Soup to Nuts by Skip Marchesani

Are you aware that a single SQL statement can process two or more tables without the tables being joined together?
http://www.mcpressonline.com/programming/sql/sql-subselect-soup-to-nuts.html

[report a broken link by clicking here]