Re: subquery in FROM must have an alias

On Sun, Sep 28, 2008 at 12:52:56AM -0400, Ashutosh Chauhan wrote:
> select a,b
>     from (billing.item JOIN (
>             select *
>             from ( billing.invoice JOIN billing.customer
>                                    on (id_customer_shipped = customer_uid and
> address = 'pgh' ))
>                         as temp2 ))
>        as temp;

change last 2 lines to:
                         as temp2 )
        as temp);

best regards,

depesz


--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007