[Help] How do i update multiple rows in a table

How do i update multiple rows in a table base on multiple rows of a different table. OKie if that is vague.. i write down the sql statement which works in sql server.

UPDATE TABLEA, TABLEB SET TABLEACOLUMN2 = TABLEBCOLUMN2 WHERE TABLE1COLUMN1 = TABLE2COLUMN1 basically what i want is to update table a with whatever data that is in table2.

I need to do that in sql statement.

Thanks

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!