RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Jeremy Allen
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

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Philip Arnold - ASP
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.

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Donn
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

RE: SQL Update - Now I'm royally confused

2001-02-20 Thread Philip Arnold - ASP
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"