unique update using a JOIN?

[window2]

I need something rather unique...
I have an older table with data like this:

Table Name:
table1

Column names:

PropertyID
Field
Amount

The use of this was that the "Field" column had a set value like "price" and the "Amount" column had the price... say "1,000". The "PropertyID" is what matched up to a second table (lets call it table2) that had a matching "PropertyID" column.

I am now trying to use just table2 and want to migrate the values from table1 to table2 all at once. I need to write an MySQL query or a PHP page that can grab the values from table1, and UPDATE table2 inserting the value of the column "Amount" in a new column called "Price" in table2, where table2.PropertyID=table1.PropertyID.

I have tried a few things but I am missing something. Hope someone can help.

[rosland]

As this will be a one-time operation, you won't need a join at all.
Just run a very simple extract/update script like examplified below, and your table2 will contain all prices from table1.
(that is if the column price already exists in table2. If not you have to add that column first)

mysql_connect($host, $user, $password) or die(mysql_error());
mysql_select_db("DB_name") or die(mysql_error());

$sql = "select PropertyID, Amount FROM table1";
$res = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_array($res))
{
    $sql = "UPDATE table2 SET Price = ".$row[1]." WHERE PropertyID = ".$row[0];
    mysql_query($sql) or die(mysql_error());
}