Multiple photographs taken with different light sources can be blended together to create images that appear to have all the light sources simultaneously active. The light sources can be attributed arbitrary colors as well, allowing the creation of an infinite number of synthetic scenes.
Quoting from Synthetic Lighting for Photography by Paul Haeberli:
Light from different light sources add together to illuminate objects in a scene. We can use this super-position principle to modify the lighting of a scene after it has been photographed...
I've created an interactive application with three light sources with different colors.
Hover over the image to change the intensities of the three light sources.
The original images I used are below.
I had snatched them a while ago from a search result on Google Images but I can't find the actual source anymore. So, this will have to go without credit. Please drop me a comment if you know the source of these images.
Light coming from the left
Light coming from the top
Light coming from the right