The behavior of column matching in subqueries is a little peculiar, to say the least.  If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for some of us it just takes a while to sink in. This morning I wasted a good five minutes ''troubleshooting'' a query that wasn't working out the way I ...