paul_lautman@yahoo.com says...
>
> Stan R. wrote:
> > Actualyl if MYsql allowed
> > subqueries the way Oracle did (like in the FROM list)
>
> It does, although I usually use JOINs instead

Oracle's
WITH <subquery> SELECT
and
FROM <subquery>
allow you to do some things that simple ANSI joins just can't match.

Geoff M