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]
