Hamilton police are investigating a fatal shooting that has left two dead in a residential area in Stoney Creek.