I found this example in the doc of mysql. I have a similar problem. Is there any solution to this?
Thanks
Update one field with more fields from another table
Table A +--------+-----------+ | A-num | text | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | +--------+-----------+
Table B: +------+------+--------------+ | B-num| date | A-num | | 22 | 01.08.2003 | 2 | | 23 | 02.08.2003 | 2 | | 24 | 03.08.2003 | 1 | | 25 | 04.08.2003 | 4 | | 26 | 05.03.2003 | 4 |
I will update field text in table A
with
UPDATE `Table A`,`Table B`
SET `Table A`.`text`=concat_ws('',`Table A`.`text`,`Table B`.`B-num`," from ",`Table B`.`date`,'/')
WHERE `Table A`.`A-num` = `Table B`.`A-num`
and come to this result Table A +--------+------------------------+ | A-num | text | | 1 | 24 from 03 08 2003 / | | 2 | 22 from 01 08 2003 / | | 3 | | | 4 | 25 from 04 08 2003 / | | 5 | | --------+-------------------------+ (only one field from Table B is accepted)
But i will come to this result Table A +--------+--------------------------------------------+ | A-num | text | | 1 | 24 from 03 08 2003 | | 2 | 22 from 01 08 2003 / 23 from 02 08 2003 / | | 3 | | | 4 | 25 from 04 08 2003 / 26 from 05 03 2003 / | | 5 | | +--------+--------------------------------------------+
Department of Genetics Faculty of Veterinary Medicine University of Liege Bd de Colonster B43 B4000 Liege, Belgium 32-43-66.41.59
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
