Home Forums SQL Server 7,2000 T-SQL Weird "Group By" Behavior from Subquery with Derived Table RE: Weird "Group By" Behavior from Subquery with Derived Table
Jonathan
SSC-Insane
Points: 20427
More actions
January 26, 2004 at 2:53 pm
#491681
Okay, I see why that "correlated derived table" works. It doesn't need to be a derived table, and the query optimizer automatically reduces it to a simple correlated subquery.
--Jonathan