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
Update Table1 set Table1FieldName=(select Table2FieldName from Table2 where
Table2ModelNo=123)
where Table1ModelNo=123
This is the general idea...
Joe
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED]
> -Original Message-
> From: Srimanta [mailto:[EMAIL PROTECTED]]
> Sent: Sunda
2 matches
Mail list logo