// I'm trying to copy a column with data from a table to another table in MySQL. But I can't wrap my head around it. BOTH TABLES have an id // COLUMN called 'nid' which fits perfectly.

// I want TO move the COLUMN called 'field_pref_position_value' FROM the TABLE 'content_field_pref_position' TO the COLUMN 'pref_position' IN the // TABLE 'content_type_transfer'. I already made the COLUMN 'pref_position'.

// Something IS wrong WITH my query, it RETURNS no errors but the RESULT: 'Your SQL query has been executed successfully
// ( Query took 0.0017 sec )' WITHOUT updating any COLUMNS at ALL. What am I missing?

UPDATE content_type_transfer JOIN content_field_pref_position ON content_field_pref_position.nid = content_type_transfer.nid SET content_type_transfer.pref_position = content_field_pref_position.field_pref_position_value