On Thu, Jul 03, 2003 at 20:37:27 +0200,
jose antonio leo <jaleo8(at)storelandia(dot)com> wrote:
> Hi all,
>
> I need do a update from t1 set col='P' where int_art = (SELECT int_art from
> t2 ....).
> I know that thios sentence is not correct but I'd like do the update for
> everethigs rows that return the select.
You want something like:
update t1 set col = 'P' from t2 where t1.int_art = t2.int_art;