Hi Kate, You use two different verbs in the explanation of your problem, update and insert, and I am not at all sure if the problem is with your statement or with your intent.
UPDATE is the SQL command to *change* values in existing data INSERT is the SQL command to *add* new data to a table So are you trying to add new data (INSERT) or change existing information (UPDATE)? Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Kate Legere" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> cc: 07/08/2004 01:49 Fax to: PM Subject: Update trouble I'm trying to retrieve a certain ID row from a table and use Update to insert it into a specific row of another table. I'm not getting any syntax error but I'm also not getting the update to work UPDATE linksProjects LEFT JOIN categories ON linksProjects.categoryId = categories.categoryId SET linksProjects.categoryId = categories.categoryId WHERE categories.catTitle = 'Vision'; Kate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]