| From: | Charley Tiggs <ctiggs(at)xpressdocs(dot)com> |
|---|---|
| To: | <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Update Query Problem |
| Date: | 2005-12-13 17:37:00 |
| Message-ID: | 5A972770-788D-4463-947C-6CD400B63252@xpressdocs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Dec 13, 2005, at 11:30 AM, <operationsengineer1(at)yahoo(dot)com>
<operationsengineer1(at)yahoo(dot)com> wrote:
> 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...
There needs to be a reference to t_serial_number in the update clause:
UPDATE t_job_number, t_serial_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
Charley
| From | Date | Subject | |
|---|---|---|---|
| Next Message | s anwar | 2005-12-13 17:37:24 | How to recover space from a failed cluster |
| Previous Message | operationsengineer1 | 2005-12-13 17:30:43 | Update Query Problem |