I have not tested this but try
UPDATE t1
SET table1.Title=table2.Title,
table1.Body=table2.Body,
table1.Section=table2.Section
FROM table1 t1
INNER JOIN table2 t2 ON(t1.ID = t2.ID)
I think the way you are doing it will not work
because of your placement of the join clause.
Play with
I have not tested this but try
UPDATE t1
SET table1.Title=table2.Title,
table1.Body=table2.Body,
table1.Section=table2.Section
FROM table1 t1
INNER JOIN table2 t2 ON(t1.ID = t2.ID)
I think the way you are doing it will not work
because of your placement of the join clause.
Hint look at the SELECT INTO Statement
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 8:16 AM
To: CF-Talk
Subject: RE: SQL Update - Now I'm royally confused
I have not tested this but try
UPDATE t1
SET table1.Title=table2
Hint look at the SELECT INTO Statement
Normally I wouldn't have this problem, but I think the 80+ hour weeks are
catching me up
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
4 matches
Mail list logo