List:General Discussion« Previous MessageNext Message »
From:Kate Legere Date:July 8 2004 5:49pm
Subject:Update trouble
View as plain text  
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

Thread
Update troubleKate Legere8 Jul
Re: Update troubleSGreen8 Jul