Updating table with reference to another table 1

[aalnaif]

I am trying to update two columns of a table (date and location) so that they are equal to the date and location of another table on a lastname join. Here's is the code I have right now:

update tblA
set tblA.date = tblB.date, tblA.location = tblB.location
where tblA.lastname = tblB.lastname;

I am getting a syntax error with the above code. Does anyone know how to do this?

 

[r937]

UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;

this is straight from the manual for the UPDATE statement --

http://dev.mysql.com/doc/refman/5.0/en/update.html

notice how both tables are mentioned (yours mentions only one table)

holler if you need help adapting it to your situation



r937.com | rudy.ca

 

[aalnaif]

Thanks r937, it works now!