Crossposted to StackOverflow.
In reply to Re: sql join with multiple select by Corion in thread sql join with multiple select by bigup401