Update table from another table

[poscribes]

I am trying to get the records added to one table to update the records of another table using the following query:

$query = "update tapes, checkin SET tapes.file_id = 'checkin.file_id', tapes.creation_date = 'checkin.creation_date' where tapes.tape_id = 'checkin.tape_id'";
$result = mysql_query($query) or die("Error: ".mysql_error());

The query completes successfully but does not update the information in the table 'tapes' with the information found in 'checkin'.

What am I missing?

Any suggestions appreciated.

[poscribes]

Okay,

Figured it out, I realized that I am trying to update values from one field to another within two different tables and not set explicit values, therefore the ' ' around the fields is not required. As such the following works perfectly:

$query = "update tapes, checkin SET tapes.file_id = checkin.file_id, tapes.creation_date = checkin.creation_date where tapes.tape_id = checkin.tape_id";
$result = mysql_query($query) or die("Error: ".mysql_error());