From: | "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | join problem |
Date: | 2007-06-13 13:19:05 |
Message-ID: | 466FEEC9.4050300@lake-lotawana.mo.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)lake-lotawana(dot)mo(dot)us
hook(at)lota(dot)us
avanhook3(at)comcast(dot)net
(816) 578-4704 - Home
(816) 564-0769 - Cell
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2007-06-13 13:44:40 | Re: join problem |
Previous Message | Albe Laurenz | 2007-06-13 13:09:56 | Re: setof or array as input parameter to postgresql 8.2 functions |