RE: Update Join with Aliases

2007-11-30 Thread Jerry Schwartz
d 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Elissa Joan [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 12:05 PM > To: mysql@lists.mysql.com >

Update Join with Aliases

2007-11-30 Thread Elissa Joan
Hello. I am having a time trying to get this to work. I hope someone can help me wit the syntax! Here is the original query: UPDATE ambien_nev.Sections INNER JOIN ambien_nev.Sections ON natural_db.Sections.section_id = ambien_nev.Sections.section_id SET ambien_nev.Sections.feature1 = natu