I presume you're thinking of the Pitt Club, but that's very, very exclusive - most Cambridge students don't go there. Generally, people go to Cindies (Ballare), Fez and Revs, but as tommm says, generally they go in the week, and on the weekend are to be found in college bars.