| From: | OTR Comm <otrcomm(at)wildapache(dot)net> |
|---|---|
| To: | PGSQL Novice List <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Strange Query Question |
| Date: | 2000-11-20 19:55:25 |
| Message-ID: | 3A1981AD.70540BD4@wildapache.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
I found a query in some code that I am evaluating:
$query = qq|SELECT ap.id, ap.invnumber, vendor.name,
acc_trans.transdate, ap.invoice, acc_trans.amount
FROM ap, acc_trans
WHERE $where
AND acc_trans.accno = $form->{accno}
AND acc_trans.trans_id = ap.id
AND ap.vendor = vendor.id|;
The code executes properly, but I do not see how this query can work
without a FROM reference to the vendor table. How does this happen?
I do not understand how you can have a reference to 'vendor.id' here
with reference to the vendor table (which does exist in the database).
Incidently, '$where' is set to 'true' in previous code prior to building
the query.
Thanks,
Murrah Boswell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-11-20 20:12:57 | Re: Strange Query Question |
| Previous Message | mat | 2000-11-20 15:06:58 | Re: Re: [GENERAL] Some problem on the data base server ! |