> 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"
**
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
>
> 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 cl
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 tha
4 matches
Mail list logo