UPDATE `Table A`,`Table B` SET `Table A`.`text`=concat_ws('', `Table
B`.`B-num`," from ",`Table B`.`date`) WHERE `Table A`.`A-num` = `Table
B`.`A-num`
Hope it works
Nitin
----- Original Message -----
From: "Wouter Coppieters" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 13, 2004 12:55 PM
Subject: Update one field with more fields from another table
> Dear mysql user
>
> 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]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]