On Thu, Jul 03, 2003 at 20:37:27 +0200,
jose antonio leo <[EMAIL PROTECTED]> 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;
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
