David Etheridge

A random example of setting a table field to value of several CONCATenated fields from a separate table.



update comments set created_by = (select CONCAT(users.surname, ', ', users.forename, ' - ', users.email) from users where users.id=comments.user_id) where exists (select users.email from users where users.id=comments.user_id);