The Zelda theme song that i'm talking about is the one that was absent from Ocarina of Time.
I'd love to hear this song play whilst i'm riding across Hyrule feild on Epona.
This is a version of the song just to give you the idea of what song i'm thinking of. I'll look for a better version though.
Ok found some moderately better versions. Scroll down to the bottom where it lists Theme Song (check out the mario paint one!).