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 |

Subqueries in version 4.1

Thanks in advance. Wouter Coppieters 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]