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]