<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