multiple table update

[Jav Travis]

update gci_copy,dis set 
gci_copy.products_description=concat_ws('<br>',gci_copy.products_description,dis.products_model,dis.products_description) 
where gci_copy.products_image=dis.products_image

only able to caoncat one match
possiable work arounds.
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]