INSERT INTO machinesongs SELECT song,(SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2') FROM songs;