Songs that mention fairs, rides, the circus...

[catlover79]

Tears of a Clown - Smokey Robinson & The Miracles

First Time on A Ferris Wheel - Smokey Robinson & Syreeta

Love Rollercoaster - Ohio Players

[Janice]

Scarborough Fair - Simon & Garfunkel

Send In The Clowns - Judy Collins

Love Rollercoaster - The Ohio Players

(Have I Stayed) Too Long At The Fair - Barbara Streisand

[Zoneboy]

Carnival - Natalie Merchant
Circus Girl - Michael Jackson
Ferris Wheel - The Everly Brothers
On a Carousel - The Hollies
Ride My See-Saw - The Moody Blues

[catlover79]

Then You May Take Me To The Fair - from the musical Camelot

[Zoneboy]

The Clown - Conway Twitty
Cathy's Clown - The Everly Brothers
Give Me a Ride (Roller Coaster) - REO Speedwagon
Iceberg - 10cc
Come On Now - The Ramones

[Ohio8]

Freddy Cannon/"Palisades Park"

[AB]

Must Let The Show Go On - Three Dog Night (loosely based on the circus)

[JoPol_wannabe]

Heart don't forget something like that- Tim Magraw- at the beginning he sings It was labor day weekend I was 17 bought a coke and some gasoline and I drove out to the country fair.
Merry Go Around- Martha Byrne
County Fair- Chris LeDoux

[Zoneboy]

Amarillo By Morning (I'll Be Bucking at the County Fair) - George Strait
Spinning Wheel - Blood, Sweat & Tears

[Fleet]

Freddy Cannon/"Palisades Park"
That's the first one I thought of... his 1962 hit.
Here is a video of it:
http://www.youtube.com/watch?v=GYDSFKLu-TA

[sara]

How about The Beatles-Being For the Benefit Of Mr Kite.

[Ohio8]

This song by "Slowhand":

[Zebra 3]

Psycho Circus (http://www.youtube.com/watch?v=QXrUKjTV7t0) - KISS