Re: update based on query results question

From: Dmitry E. Loginov <lde_at_mpsb.ru>
Date: Tue, 5 Jul 2005 20:53:34 +0400
Message-ID: <daedru$1tmg$1@news.caravan.ru>

"Justin" <nospam_at_insightbb.com> wrote in message news:slrndclbih.cgd.nospam_at_debian.dns2go.com...
> I have an update statement that updates 40 rows based on the
> results of a select query. The select query when run by itself returns
> about 250 rows.
>
> I am trying to set the value of another column in a table based on the
> query results of the select statement.
>
> So, basically, it's
>
> update <table> set <columnb> where <columna> in (select distinct
> a.column from tablea a, tableb b where a.column=b.column);
How much recs returns query:
select * from <table> where <columna> in (select distinct

a.column from tablea a, tableb b where a.column=b.column); ?

> I've probably got some stupid mistake there...
Received on Tue Jul 05 2005 - 11:53:34 CDT