cc:
07/08/2004 01:49 Fax to:
PM Su
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 lin
Richard,
Thursday, March 28, 2002, 5:19:03 PM, you wrote:
RM> I am trying to do a table update. The table I am updating is a results
RM> table.
RM> I have constructed a query, however, it doesn't seem to work because in the
RM> where statement I need to refer to a different table:
RM> update c
