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" **

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 >

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 cl

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 tha