Message-ID: <466FF4C8.3010006@lelarge.info>
Date: Wed, 13 Jun 2007 15:44:40 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Thunderbird 2.0.0.0 (X11/20070326)
MIME-Version: 1.0
To: "A. R. Van Hook" <hook@lake-lotawana.mo.us>
CC: pgsql-sql@postgresql.org
Subject: Re: join problem
References: <466FEEC9.4050300@lake-lotawana.mo.us>
In-Reply-To: <466FEEC9.4050300@lake-lotawana.mo.us>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

A. R. Van Hook a écrit :
> I have join problem:
> "select i.ivid, v.eventdate, v.deposit, v.invdate, cai.db,
>                 sum(i.tax) as tax,
>                 sum(i.tax + i.rowtot) as totalP,
>                 (sum(i.tax + i.rowtot) - v.deposit) as balance
>               from invoice v
>               left outer join
>                      invoiceitems i
>                 on  v.ivid = i.ivid
>               where v.cusid = $cusid
>                     and   v.cusid = cai.cusid                group by
> i.ivid,  v.eventdate, v.deposit, v.invdate, cai.db
> ERROR:  missing FROM-clause entry for table "cai"
> 
> If I add cai to the from clause "from invoice v, cai,  I get
> ERROR:  missing FROM-clause entry for table "cai"
> ERROR:  invalid reference to FROM-clause entry for table "v"
> 
> Where do I add the cai table reference???
> 

You probably need to change the order of the tables in the FROM clause.
Replace
  FROM invoice v, cai
with
  FROM cai, invoice v


Regards.


-- 
Guillaume.
<!-- http://abs.traduc.org/
     http://lfs.traduc.org/
     http://docs.postgresqlfr.org/ -->