Message-ID: <466FF6B9.1050103@fbl.cz>
Date: Wed, 13 Jun 2007 15:52:57 +0200
From: Ales Vojacek <alesv@fbl.cz>
Reply-To: alesv@fbl.cz
User-Agent: Thunderbird 2.0.0.0 (Windows/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=UTF-8
Content-Transfer-Encoding: 8bit

You can do it like this:

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
	      join cai on v.cusid = cai.cusid
              left outer join
                     invoiceitems i
                on  v.ivid = i.ivid
              where v.cusid = $cusid
           group by i.ivid,  v.eventdate, v.deposit, v.invdate, cai.db

A.

Aleš Vojáček
FBL Group spol. s r.o.
e-mail: alesv@fbl.cz
mobil: +420603893335


A. R. Van Hook napsal(a):
> 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
>