This should work with SQL Server
update table1
set price = b.price
from table1 a join table2 b on a.productid = b.productid
and a.modelno = b.modelno
I have two tables in a DB containing information about the same
products. Table 1 is comprehensive and has complete details about
the
Hi,
I have two tables in a DB containing information about the same products.
Table 1 is comprehensive and has complete details about the products.
Table 2 has fewer no of fields.
The fields common in both Table 1 and Table 2 are productid, modelno, price,
details .
Table1.price contains the
, October 06, 2002 8:56 PM
To: CF-Talk
Subject: Update Problem in CF
Hi,
I have two tables in a DB containing information about the same products.
Table 1 is comprehensive and has complete details about the products.
Table 2 has fewer no of fields.
The fields common in both Table 1
3 matches
Mail list logo