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]