From: A. R. Van Hook <hook@lake-lotawana.mo.us>
To: pgsql-sql@postgresql.org
Subject: join problem
Date: Wed, 13 Jun 2007 08:19:05 -0500
Message-ID: <466FEEC9.4050300@lake-lotawana.mo.us> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hook@lake-lotawana.mo.us
Subject: Re: join problem
In-Reply-To: <466FEEC9.4050300@lake-lotawana.mo.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox