Quite simple but something I can never seem to remember: INSERT INTO files_users (file_id, user_id) SELECT id, '2' FROM efs.files; found @ http://mysq