Re: replace subquery with left join

From: Serge Rielau <>
Date: Thu, 31 Oct 2002 07:07:49 -0500
Message-ID: <>

Take a look at OLAP functions, they are SQL99. Supported at least by Oracle and DB2. Don't knwo about SQL Server.


Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Toronto

Visit DB2 Developer Domain at
Received on Thu Oct 31 2002 - 13:07:49 CET

Original text of this message