Re: Problem UPDATE Statement - Mailing list pgsql-novice

<operationsengineer1@yahoo.com> writes:
> i'm trying to apply the following UPDATE statement:
> UPDATE t_sn
> SET t_sn.sn_completed = false
> WHERE sn = 1
> AND t_sn.link_id = t_link.link_id
> AND t_link.job_id = t_job.job_id
> AND t_job.product_id = t_product.product_id
> AND t_product.product_id = 118

> i get the following error:

> ERROR:  missing FROM-clause entry for table "t_link"

You need a "FROM t_link" in there.  Prior versions of PG were laxer
about this, but it's been a very long time since this command wouldn't
draw at least a NOTICE ...

            regards, tom lane