You are joining ambien_nev.Sections to itself, but the join condition natural_db.Sections.section_id = ambien_nev.Sections.section_id references a data base that isn't in the join. I think that might be the problem.
Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 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 > Subject: Update Join with Aliases > > 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 = natural_db.Sections.feature1, > ambien_nev.Sections.feature2 = natural_db.Sections.feature2, > ambien_nev.Sections.feature3 = natural_db.Sections.feature3, > ambien_nev.Sections.feature4 = natural_db.Sections.feature4, > ambien_nev.Sections.banner_image = natural_db.Sections.banner_image; > > Which gives the message: Not unique table/alias: 'Sections' > > So I tried aliases: > > UPDATE ambien_nev.Sections as SectionsSp > INNER JOIN SectionsSp ON natural_db.Sections.section_id = > SectionsSp.section_id > SET SectionsSp.feature1 = natural_db.Sections.feature1, > SectionsSp.feature2 = natural_db.Sections.feature2, > SectionsSp.feature3 = natural_db.Sections.feature3, > SectionsSp.feature4 = natural_db.Sections.feature4, > SectionsSp.banner_image = natural_db.Sections.banner_image > > Which gives the message: Not unique table/alias: 'SectionsSp' > > Help! And a million thanks in advance for any help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
