Ive heard this song melody before. I thought maybe weezer used it in their song Only In Dreams.
You can hear it at 3:10 in THIS VIDEO it will not reflect the original song because the song starts late in this video
http://www.youtube.com/watch?v=TR_yHQhSyI4
Go check that out start at 3:09 or 3:10 ive heard the melody in my sisters video game before too. Some elmo game online what song is it from?