From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: join problem |
Date: | 2007-06-13 13:44:40 |
Message-ID: | 466FF4C8.3010006@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
A. R. Van Hook a écrit :
> 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???
>
You probably need to change the order of the tables in the FROM clause.
Replace
FROM invoice v, cai
with
FROM cai, invoice v
Regards.
--
Guillaume.
<!-- http://abs.traduc.org/
http://lfs.traduc.org/
http://docs.postgresqlfr.org/ -->
From | Date | Subject | |
---|---|---|---|
Next Message | Ales Vojacek | 2007-06-13 13:47:36 | Re: join problem |
Previous Message | A. R. Van Hook | 2007-06-13 13:19:05 | join problem |