Message-ID: <466FEEC9.4050300@lake-lotawana.mo.us>
Date: Wed, 13 Jun 2007 08:19:05 -0500
From: "A. R. Van Hook" <hook@lake-lotawana.mo.us>
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: join problem
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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???

thanks

-- 
Arthur R. Van Hook
     Mayor - Retired
 The City of Lake Lotawana

hook@lake-lotawana.mo.us
hook@lota.us
avanhook3@comcast.net
(816) 578-4704 - Home
(816) 564-0769 - Cell