update based on query results question

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);

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