> 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
that and see if it helps Phillip.
Jeremy Allen
elliptIQ Inc.
>-Original Message-
>From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, February 20, 2001 9:33 AM
>To: CF-Talk
>Subject: SQL Update - Now I'm royally confused
>
>
>OK, aft
OK, after that SP question, and some experimentation, I've decided to start
doing most of the work with CF, and then shift over to SPs when I know I've
got the SQL working
Anyway, I'm trying to do the update from one table to another in SQL using a
JOIN - it's SQL Server 7
update table1 inner jo
5 matches
Mail list logo