Re: join problem

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