Sunday, September 28, 2008

Re: [GENERAL] 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: