hi there, hope in your help.

I've this two tables in mysql database:
Code:
mysql> SELECT 
       Nm,
       zone,
       sID,
       ID
        FROM
	myTable;

+-------+------+-----+-----+
| Nm    | zone | sID | ID  |
+-------+------+-----+-----+
| AAA   | XY5N | 10  |  1  |
| BBB   | XY5N | 10  |  2  |
| CCC   | XY5N | 10  |  3  |
| DDD   | XY5N | 10  |  4  |
| EEE   | XY5N | 10  |  5  |
| FFF   | XY5N | 10  |  6  |
| GGG   | XY5N | 10  |  7  |
+-------+------+-----+-----+
7 rows in set


mysql> SELECT
	Nm,
	zone,
	ID
FROM
	myTableCopy;
+-------+------+----+
| Nm    | zone | id |
+-------+------+----+
| NULL  | XY5N | 10 |
+-------+------+----+
1 row in set
I need update the field Nm of table 'myTableCopy' appending all values of tabel 'myTable' where the same 'zone'.

I tried this query, don't have error but the update not working, can you help me please?
thank you in advance.

the output:
Code:
+------------------------------------+------+----+
| Nm                                 | zone | id |
+------------------------------------+------+----+
| AAA; BBB; CCC; DDD; EEE; FFF; GGG  | XY5N | 10 |
+------------------------------------+------+----+
the query:
Code:
UPDATE myTableCopy t1
JOIN (
	SELECT
		Nm,
		zone
	FROM
		myTable
) AS t2 ON t1.Zone = t2.Zone
SET t1.Nm = CONCAT(t1.Nm, ';', t2.Nm);