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: [EMAIL PROTECTED] / aim:depeszhdl / skype:depesz_hdl / gg:6749007

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

Reply via email to