It's at times like this I realise my SQL skills only cover the basics... I have two tables, 'user' and 'users_names'. I'm looking to deprecate 'users_names', so I've altered 'user' to now contain a 'user_realname' column. Both tables have a column 'user_id', which correspond to each other. I'd like to take the data from 'users_names.name' and put it into 'user.user_realname' where the 'user_id' column match. I just can't seem to find the SQL to make MySQL do this.
Any ideas? +Pete -- Almost every man wastes part of his life attempting to display qualities which he does not possess. -- Samuel Johnson