For a great tutorial on using in-camera multiple exposure and on how to use photoshop to create multiple exposure effects, see Photoextremist's video: