| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Update Query Problem |
| Date: | 2005-12-13 17:30:43 |
| Message-ID: | 20051213173043.18149.qmail@web33304.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
the following update query...
UPDATE t_job_number
SET contract_id = 30
WHERE t_serial_number.serial_number_id = 78
AND t_serial_number.job_number_id =
t_job_number.job_number_id
yields the following chastisement...
ERROR: missing FROM-clause entry for table
"t_serial_number"
can anyone point in the right direction? requiring a
from clause in this update seems a little bizarre to
me - so i'm sure i've botched something up pretty
good.
tia...
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charley Tiggs | 2005-12-13 17:37:00 | Re: Update Query Problem |
| Previous Message | Agnes Bocchino | 2005-12-13 09:34:57 | Re: transaction ID wrap limit is 2147484146 Start Postgresql |