Re: WITH Support

The WITH that I am thinking about, lets you define and reuse queries which are executed once.  For example: 

WITH  MySummary AS (*SELECT b.dept_name, Sum(Salary) AS total_sal FROM emp a join dept b on (a.dept_id = b.dept_id)
GROUP BY b.dept_name*)  SELECT dept_name, total_sal //FROM MySummary  WHERE total_sal > (                     SELECT
SUM(total_sal) * 1/12                     FROM MySummary)  ORDER BY total_sal
 

You can introduce multiple "aliases" and use them within any subsequent queries.

WITH   alias1 as (...)  alias2 as (...)  alias3 as (...)
SELECT ....

Thanks,


> Edwin Ramirez wrote:
> > Hello,
> > 
> > What is the status of supporting the "WITH" keyword?
> 
> I see these TODO items:
> 
>     * Add SQL99 WITH clause to SELECT
>     * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
> 
> Are they the same item?