Re: [SQL] sub query and AS

2012-05-24 Thread Samuel Gendler
On Wed, May 23, 2012 at 12:07 PM, Lee Hachadoorian < lee.hachadooria...@gmail.com> wrote: > On Wed, May 23, 2012 at 5:24 AM, Ferruccio Zamuner > wrote: > > Hi, > > > > I like PostgreSQL for many reasons, one of them is the possibility to use > > sub query everywhere. Now I've found where it doesn

Re: [SQL] sub query and AS

2012-05-23 Thread Lee Hachadoorian
On Wed, May 23, 2012 at 5:24 AM, Ferruccio Zamuner wrote: > Hi, > > I like PostgreSQL for many reasons, one of them is the possibility to use > sub query everywhere. Now I've found where it doesn't support them. > > I would like to use a AS (sub query) form. > > This is an example: > > First the s